Forum Discussion
Adding the week data in the Date Slicer
Hey Guys,
Is there a way to add the week into the hierarchy slicer,
As of now, i have the hierarchy as Year / Quarter / Month /Date
i wanted Week between Month & date , Like -> Year / Quarter / Month / Week / Date
Please Suggest
Anonymous ,
You need to create a week number column using dax function weeknum() and then build a custom hierarchy using the date column and the week number column. You can refer to tutorial below about how to build custom hierarchy column in power bi:
https://www.youtube.com/watch?v=WWvVeYU0Dvw
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
- Greg_Deckler
Community Champion
You could create individual columns for Year, Quarter, Month, Week and Day using YEAR, QUARTER, MONTH, WEEKNUM and DAY and build your own hierarchy.
v-yuta-msftCommunity Support
Anonymous ,
You need to create a week number column using dax function weeknum() and then build a custom hierarchy using the date column and the week number column. You can refer to tutorial below about how to build custom hierarchy column in power bi:
https://www.youtube.com/watch?v=WWvVeYU0Dvw
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
