Using switch to change value used in filter

[opittaluga]

Hello community, I hope you can point me to the right path.

Im trying to build a report with a switch with three options: Product, category and client.  one filter that changes depending the option you choose on the switch and finally a Column chart that is affected by the filter.

That will give the option of working with only one column chart but with three different type of information.

For example: The idea is that when I choose Product a  filter will show the products you can filter from a column chart. But when I choose the category the filter change and show the categories that affect the column chart. Same Idea with clients.

[TomMartens · Accepted solution]

Hey,

I guess this explains pretty well what you are looking for:

http://www.leanx.eu/tutorials/dynamic-dimensions-in-power-bi

Regards,

Tom