Drilldown/slicer Headaches

[dramus]

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 hierachy for this in SSAS, but I'm having difficulty getting the same functionality to work in Power BI Desktop.

Does anyone have any suggestions or having similar issues?

[Anonymous]

Hi darmus,

As of my knowlage, there is no support of filtering while performing a drill-down. My solution would be to use a couple of slicers for each layer in the drill-down.

The other method would be, as listed above, that you use a live connection to the SSAS Model, where hierachy is supported.

Use this link for more information: https://powerbi.microsoft.com/en-us/documentation/powerbi-analysis-services-connector/

[greggyb]

You can vote for drill-down to cross-filter here.

[greggyb]

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]

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]

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