Forum Discussion
Using calender week and year in diagrams
Hey,
i want to use calender week and year in my diagram as time. Therefore if I select only one year, it should only show the calender weeks , but by zooming out it should show the calender weeks and beneath that it should show that year and starting over again, looking like:
1 2 3 (..) 54 1 2 3 (..) 54
2018 2019
But there is no date format i can my data transform to. Can somebody help me?
Thanks in advance!!
3 Replies
- Mariusz
Community Champion
Hi Anonymous
You can create a date dimension / calendar table as in the article below.
https://radacad.com/create-a-date-dimension-in-power-bi-in-4-steps-step-1-calendar-columns
Later you will be able to use Year and week number as a hierarchy in your visuals
Best Regards,
Mariusz
If this post helps, then please consider Accepting it as the solution.
Please feel free to connect with me.
LinkedIn - amitchandak
Super User
Anonymous
Refer this file. You can use the week start or weekend date.
https://www.dropbox.com/s/d9898a48e76wmvl/sales_analytics_weekWise.pbix?dl=0
HI Anonymous,
You can extract your table records values and use them in the calendar function to create a calendar table, then it will be analyzed as date hierarchy with different date dimensions.
Notice: date hierarchy does not contain week level, you can use your date fields on 'timeline slicer' or manually add a custom column with weeknum functions.
Regards,
Xiaoxin Sheng
