Slice Data based on Filter Selection Switch Measure

[thibbos]

Hi all,

I have created a slicer with a SWITCH function in order to SWITCH between measures.

Example:

Measure 1 = Sales PRODUCTS COLOR BLUE

Measure 2 = Sales PRODUCTS COLOR RED

Now the question is the following:

In my visual table all products are shown wether i filter on Measure 1 or on measure 2. I would like the table to be filtered as well to the Products of colour Blue in case selection is MEASURE 1 and products of colour red when selction is MEASURE 2.

Have looked around and don't really understand how i could achieve it, as most of measures doesn't allow me to filter on columns (request measures).

Hope that's clear,

Thanks

Thibault

[v-henryk-mstf]

Hi @thibbos ,

Here is a similar case that has been solved, please refer to whether it can help you.

Here is the link:

If there are still no results for your question, can you provide sample data and detailed information so that I can do further testing? Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[thibbos]

Hi @v-henryk-mstf 

Thanks for your input. I came accross that post, unfortunately it does not do what I want. Because it filters the results of the measure you are switching based on input. 

My measure needs to filter the products table accordingly, hence why i used the filter as @amitchandak  suggested.

Thanks anyway

[amitchandak · Accepted solution]

@thibbos , One way is bookmarks and button :https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive

Another way is to have the filter of products in the measure

[thibbos]

@amitchandak I used your second proposal to filter in the measures. Very efficient and so obvious, thanks