Forum Discussion
Filter on Click with Stacked Bar Chart with Year
No idea. Maybe it is easier for someone starting with Power BI. Or I just haven't found a truly good use case for them. But nowadays even the standard slicer supports multiple fields which show as an ad-hoc hierarchy too.
I'm not using auto date/time to my knowlege. I have a full date table with a manually created date hirearchy (year > month) which is used as the date field for the table I'm having issues with.
Date table DAX:
Date = ADDCOLUMNS(
CALENDARAUTO(),
"Month", FORMAT([Date], "mmmm"),
"Year", YEAR([Date]),
"Day", DAY([Date]),
"Month Number", MONTH([Date]))
Super UserLet me extend that. Try not to use any of the built in hierarchies. There's very seldom a need for them, especially when your visual doesn't use all the fields.
Are you saying to not use date hierarchies at all? I didn't use a built in hierarchy, I went into the model tab and created a hierarchy called "Date Hierarchy" with levels Year, Month.
If hierarchies don't work very well, why does the power bi training documentation suggest creating a date hirearchy?
- lbendlin
No idea. Maybe it is easier for someone starting with Power BI. Or I just haven't found a truly good use case for them. But nowadays even the standard slicer supports multiple fields which show as an ad-hoc hierarchy too.
Thanks for the insight. I'll try not using hierarchies and just layer the hierarchy in the fields for a visual instead