Forum Discussion

kylefox101's avatar
kylefox101
Frequent Visitor
4 years ago
Solved

Using Slicer as Visual Title

Hello!    I am attempting to use slicers as visualization titles, that when selected pulls the location into the corresponding table. I am running into issues when selecting more than one, presumab...
Need Help
  • v-chenwuz-msft's avatar
    v-chenwuz-msft
    4 years ago

    Hi kylefox101 ,

     

    Is this you want?

     

    If yes, please create a new table via values('fact table'[category]) for one slicer. if two slicers then two tables.

    Then create measure like the following and put it in filter pane and set it show items when is 1.

     

     

    Measure =
IF (
    SELECTEDVALUE ( 'Table'[Category] )
        IN VALUES ( Slicer1[Category] )
            || SELECTEDVALUE ( 'Table'[Category] ) IN VALUES ( Slicer2[Category] ),
    1
)

     

     

    Pbix in the end you can refer.

    Best Regards

    Community Support Team _ chenwu zhu

     

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

v-chenwuz-msft's avatar
v-chenwuz-msft
Community Support
4 years ago

Hi kylefox101 ,

 

Is this you want?

 

If yes, please create a new table via values('fact table'[category]) for one slicer. if two slicers then two tables.

Then create measure like the following and put it in filter pane and set it show items when is 1.

 

 

Measure =
IF (
    SELECTEDVALUE ( 'Table'[Category] )
        IN VALUES ( Slicer1[Category] )
            || SELECTEDVALUE ( 'Table'[Category] ) IN VALUES ( Slicer2[Category] ),
    1
)

 

 

Pbix in the end you can refer.

Best Regards

Community Support Team _ chenwu zhu

 

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