Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Slice Data based on Filter Selection Switch Measure

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

Need Help

4 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

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

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support
    5 years ago

    Hi Anonymous ,


    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      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