Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Control a Measure using Multi Selction Disconnected Slicer

Hi I'm trying to understand how to do the above.   What I want to achieve is best exampled by the following:   So I want to choose multiple selections on the blue slicer to affect the blue...
Need Help
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    7 years ago

    Thanks, v-cherch-msft  - that would have worked I think, but I have multiple features I want to slice on, and this would involve creating a slicer table for each feature, which would have got hard to maintain.

    The solution, in the end, came from my boss who had a play and worked out it was best done by creating two datasets in Power Query from one, and then having a measure in each dataset that is plotted on the visual. That way you don't need any slicer tables - you slice on the values in each dataset - I've tested and it works.

     

    The link is here to the solution - Final Solution

     

    Thanks again

v-cherch-msft's avatar
v-cherch-msft
Microsoft Employee
7 years ago

Hi Anonymous 

It seems you may create two slicer tables and then create the measure like below.Please check Page1 in attached file.

Measure =
CALCULATE (
    [Number of Rows],
    FILTER (
        Fruits,
        Fruits[Country] IN VALUES ( Country_Slicer[Country] )
            && Fruits[Feature] IN VALUES ( Feature_Slicer[Feature] )
    )
)

Regards,

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Thanks, v-cherch-msft  - that would have worked I think, but I have multiple features I want to slice on, and this would involve creating a slicer table for each feature, which would have got hard to maintain.

    The solution, in the end, came from my boss who had a play and worked out it was best done by creating two datasets in Power Query from one, and then having a measure in each dataset that is plotted on the visual. That way you don't need any slicer tables - you slice on the values in each dataset - I've tested and it works.

     

    The link is here to the solution - Final Solution

     

    Thanks again