Sorting table

[sadath]

HI,

My week name (like Week 1, Week 2, Week 3...) in slicer not showing in the right order, I tried to sort Week by Date in the calendar table
Error showing that 'at least one value in Week have multiple distinct value in Date'.

How to sort in proper order.

One more issue : some weeks are showing grayed out even though it has data.

 

[gazpage]

You probably want to add a column in your data tables where each week has an index number, ie

Week Index

Week 1 1
Week 1 1
Week 1 1
Week 2 2
Week 2 2
Week 2 2
Week 3 3
Week 3 3
Week 3 3

Then sort by this index column.