Forum Discussion
Help with filtering Date Hierachy
Hi,
If you create a Calendar table using this DAX calculated table formula, then you will not face this problem
Calendar = calendar(min(Data[Date]),max(Data[Date]))
Also, in the Calendar table, create calculated column formulas for Year, Month name and Month number. Sort the Month name column by the Month number. To your visual, drag Year and Month name from the Calendar table.
Hi,
If you create a Calendar table using this DAX calculated table formula, then you will not face this problem
Calendar = calendar(min(Data[Date]),max(Data[Date]))
Also, in the Calendar table, create calculated column formulas for Year, Month name and Month number. Sort the Month name column by the Month number. To your visual, drag Year and Month name from the Calendar table.
This is how I have it setup currently, with Calendar(Min,Max) generating the table.
Wonder if there is a way to make this work with Automatically generated date heriachy rather than creating extra columns for Year/month.
Other reply of Filter by not blank didn't work. This was tested with no fact table, only a caleandar table.
You must create a Calendar table.