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

     

     

     

     

Tahreem24's avatar
Tahreem24
Icon for Super User rankSuper User
1 year ago

Anonymous I don't know whether I understood your question properly or not. But based on my understanding, create a Measure like below:

Measure_ = IF(SELECTEDVALUE(MyTable[Market]) <> "Japan", "Show data only for Japan",SUM(MyTable[Sale]))

 

 

 

 

 

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Tahreem24 Thanks for the reply however we tried this approach and DAX as well but this is not working as the expected output.