topic Re: Clustered and stacked bar charts together for multiple x axis drill downs in DAX Commands and Tips

Clustered and stacked bar charts together for multiple x axis drill downs

Anonymous — Tue, 23 May 2023 04:35:52 GMT

Hi all,

I tried this solution to display stacked and bar chart on 3 y axis variables, one bar and two stacked https://www.villezekeviking.com/how-to-combine-a-clustered-and-stacked-chart-in-power-bi/, this works but i have 3 to 4 x axis variables and whe i drill down i am not able to put the stack and bar together for all of the drills, it appears only for the last drill down where "Type" is there.

how to make it display as 1 bar +2 stacked side by side for all the drill downs
Please help

Re: Clustered and stacked bar charts together for multiple x axis drill downs

Villezekeviking — Tue, 06 Aug 2024 20:17:00 GMT

I fear that the Type-field is required to make it work in my solution there.

That essentially means you cannot use the drill down feature that's built in.

There's however another solution you could use to work around it. If you copy the visual and have different fields in each, you can use bookmarks and buttons to make it look like you're selecting between different fields.
Another solution would be to use a field parameter and add all the fields you want to be able to drill with and then manually add the Type-field to the visual as well so that it will always be there too.