Forum Discussion
Date Hierarchy for Quick Measure Not Working
I defined a date hierarchy but the option appears greyed out and when i try to drag the columns over nothing happens..
I run into similar problem with the same setting (data source = SSAS or AAS), but it's more general.
In previous version of Power BI, I could drag any Date field, and it will expand it into Date hierarchy by default when I use Table visualization.
In the latest version (October 2018), even after enabling Show dates as a hierarchy in the field list option (https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-january-2018-feature-summary/#dateHierarchy), the Date hierarchy doesn't show up at all for SSAS/AAS data source. (The setting only works for CSV data source, though)