Adding the week data in the Date Slicer

[nalin_d]

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

[v-yuta-msft · Accepted solution]

@nalin_d ,

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.

[Greg_Deckler]

You could create individual columns for Year, Quarter, Month, Week and Day using YEAR, QUARTER, MONTH, WEEKNUM and DAY and build your own hierarchy.

[amitchandak]

Refer:https://www.tutorialgateway.org/create-hierarchy-in-power-bi/

[Anonymous]

Did you try to use WEEKNUM?

Week = WEEKNUM(Your_Table[Date], 2)

Add in the hierarchy Year, Quarter, Month, Week, Day