Multiselect Slicer interaction with Doughnut chart

[Anonymous]

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 show "Data available only for Japan" and if user select only Japan then only the data should show for japan based on the market distribution in doghnut chart. How to achieve this in Power BI. . We tried by keeping transaparent visual on top of it but the tooltips are not accessible in this scanario and we are looking for some permanent soultion to it. Below are the outputs we are getting as of now but this is wrong. we are expecting data should be blak or null when user select sin slicer as Japan and UK or Japan and Brazil or all 3 toghther It should show Data only for Japan. Also, We are expecting this should be a multiselection option.

Sample Chart in Power BI

Attaching Sample Data

Market	Source	Product	Sale
Brazil	S
Brazil	S
Brazil	S
Brazil	R
Brazil	R
Brazil	R
Japan	M	Company	1195.1
Japan	M	Company	1410.9
Japan	M	Company	1626.7
Japan	M	Company	1842.5
Japan	M	Non Company	2058.3
Japan	M	Non Company	2274.1
Japan	M	Non Company	2489.9
UK	R
UK	R
UK	R
UK	R
UK	R
UK	R
UK	S
UK	S
UK	S
UK	S
UK	S

[Anonymous · Accepted solution]

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]

@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]

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

[sangameshks]

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]

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.