Forum Discussion

BratKat's avatar
BratKat
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

Weekly data and slicer

Have a graph that uses a Slicer (using between) and a measure to get each week per a column of the dates we reference.  MonthWeek = 'Work Items'[Team Date 01].[Month] & " Week " & WEEKNUM('Work Ite...
BratKat's avatar
BratKat
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

The MonthWeek item is a measure in my data so does not appear in looking at the data in Transform, tried you method but made it worse. Is there a way I can format the date to appear instead of for example. January Week 1 to appear as 1 Week January so I can sort numerically ? Thank you 

 

BratKat's avatar
BratKat
Icon for Microsoft Employee rankMicrosoft Employee
3 years ago

Its possible may be creating the graph wrong. Am using my MonthWeek measure in the Slicer but using the Team Date in the X-Axis. Could that be an issue ? I did try using the Team Date in the Slicer however then I did not have the option of using "between" in the Slicer.