Forum Discussion

dramus's avatar
dramus
Icon for Continued Contributor rankContinued Contributor
10 years ago

Drilldown/slicer Headaches

  We have an unusual accounting calender.   The year is not calendar based The year is split into 10 periods A period is either 4 or 5 weeks long, to fill out 52 weeks.   I can create a hier...
Need Help
greggyb's avatar
greggyb
Icon for Resident Rockstar rankResident Rockstar
10 years ago

Power BI can consume hierarchies from a SSAS cube. Why not just use your already published model in live connection mode with Power BI?

fbrossard's avatar
fbrossard
Icon for Kudo Commander rankKudo Commander
10 years ago

In Power BI Dekstop you can not create hierachies in your data model.

But for many visuals you can stack attributes in axis list and navigate through the "hierachy"

 Unforunately, you have to do this for each visuals.

 

But, according to greggyb Power BI support SSAS hierachies when using Direct Connect on it.

  • dramus's avatar
    dramus
    Icon for Continued Contributor rankContinued Contributor
    10 years ago

    My problem with Drilldown charts is that they do not filter the rest of the page when you drill down.