Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Multiselect Slicer interaction with Doughnut chart

I have slicer with multi select option, japan, UK, Brazil, data is available only for Japan and datasource M, so if user select Japan and any other country, or all three countries at on go, it should...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Anonymous ,
    You can try the following steps
    Create two measures

    Text Measure = 
 IF(
    SELECTEDVALUE('Table'[Market]) <> "Japan",
    "Data available only for Japan",
    ""
 )
    Background Measure = 
IF(
    SELECTEDVALUE('Table'[Market]) = "Japan",
    "#FFFFFF00",
    "#FFFFFF"
)

    Create a card visualiization

    Go to Format Visual -> Turn of the Category lable

    Then go to General -> Effects, Cutom background color

    Cover your Donut chart with the formatted card and resize it to completely cover the Donut chart.

    Final output

     

    Best regards,
    Albert He

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

     

     

     

     

sangameshks's avatar
sangameshks
Helper I
1 year ago

Hello Anonymous ,

 

We can use custome meausre or custom column for the same or a tooltip. You know you have multiple ways to get his done. use the feasible solution. If you want multi select option in your slicer without CTRL+ then use the option inside slicer setting in slicer format option. 

 

Let me know if it works?

 

Regards,

Sangamesh KS

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hello @Sangamesh KS thanks for the suggestion however, we are actually our requirement is not for tooltip it is to show data only when user selects market as Japan but currently it is hsowing data for all other markets as well.