One visual, multiple filters but only one active at a time

[Anonymous]

A feature in ClickView (non-Power BI) is that you can have only ONE visual, to which you throw in all your data, but then you have a filter section that shapes that visual's data based on the filter you choose.

Example:

I want to have ONE pie-chart. In my dataset, I have the columns "Education" (Highschool or College), "Kids" (0 through 4) and If they own a car or not ("Yes", "No"). The pie-chart should only show one of these filters at a time.

To illustrate, here you see the pie-chart being filtered on Education:

Now I want to see how many kids all my representatives have, so by click Kids, the Education-filter is removed. It's not drilling in, it's simply re-shaping the visual based on the filter.

Is this do-able in Power-BI? These visualisations were made in Paint. 

[Anonymous · Accepted solution]

I believe this might solve the issue. Posting here while while attempting it before someone spends time answering this post. 

https://www.kasperonbi.com/dynamically-switching-axis-on-visuals-with-power-bi/

[v-piga-msft]

Hi @Anonymous ,

It seems that you have found the solution. I will mark your reply as an answer to close this thread.

Best Regards,

Cherry