Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
The message you are trying to access is permanently deleted.
leadership has asked me to track trends and wants daily reports, and weekly totals, I've got the data and bar graphs ready and used weeknum() to get the weekly numbers field, but I don't want the X Axis to show 13,14,15, 16, I'd rather it how the range of the dates involved in that week, EG week 13 is "23 - 29 March". I was able to show that via IF() but the issue is when I put that column on the X-axis it's not in the right order anymore.
How does MS not have a weekly slicer in their date hierarchy yet?
week dates on X axis :
same data by Week Num
Solved! Go to Solution.
Check out Week Starting: https://community.powerbi.com/t5/Quick-Measures-Gallery/Week-Starting/m-p/391487#M123
Hi @Anonymous ,
In power bi desktop, the date hierarchy contains Year, Quarter, Month and Day currently and I'm afraid there is no option about the number of week in this hierarchy unless you use weeknum() as you previous said.
Please Refer:
In addtion, if you want to re-sort these columns, you should change the sort by column and refer the weekstart articles as @ amitchandak and @ Greg_Deckler provided.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
You should set the week order based on week no or Year - Week No
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
Refer in this file for the Week start date and year week no(Week)
https://www.dropbox.com/s/d9898a48e76wmvl/sales_analytics_weekWise.pbix?dl=0
Check out Week Starting: https://community.powerbi.com/t5/Quick-Measures-Gallery/Week-Starting/m-p/391487#M123
thanks this seems to be similar to what I'm doing just more compact and in one step vs calculating weeknum() then doing IF() to change the text around.
Still disappointed at MS here though.
thanks everyone!