Exclude a data based on combination of Slicer

[LaurentZ]

Dear All,

First I have to say that I'm a real beginner, so sorry in advance if the answer is obvious...

I've a table with Business Unit, Country and a measure.

My slicer is the "countries". If no country is selected, it means that I want to display the Cluster.

I've a chart based on those data.

I would like to exclude from display some combination Business Unit/Country (because I have no or tiny business) but keep all category if nothing is selected.

Do you know how I could proceed ?

[v-jiascu-msft]

Hi @LaurentZ,

Can you share a dummy sample, please? Please mask the sensitive parts.

Maybe you can use a Visual Level Filter to exclude the blank values.

Best Regards,

[LaurentZ]

Here is a very simplified exemple:

No selection of Town, I want to display all fruits.

If I select London, I want to "Exclude" the Pears (but not based on the Value, just based on the combination Town/Fruits).

Something like: If "London" is selected then do not display "Pears".

The idea behind that is to "clean" data of tiny amounts, and so to keep a standard scaling in my chart.

Is it Possible ?

[v-jiascu-msft]

Hi @LaurentZ,

Can you share a dummy file, please? The solution depends on your data structure. 

This is possible. Please share the general rules that we can apply in the formula. What if we select Paris? It's a bad idea to hardcode the rules. 

Best Regards,

[LaurentZ]

Dear v-jiascu-msft 

Sorry for the laste answer, I was on holidays.

Please find a pbix file (it's not exactly the same data than in screenshot because I did not save it, so I rebuild it).

Link: pbix

Laurent

[v-jiascu-msft]

Hi Laurent,

Try this measure, please. Please refer to the snapshot below.

Measure =
VAR totalQuantity =
    SUM ( Table1[Quantity] )
RETURN
    IF ( ISBLANK ( totalQuantity ) || totalQuantity = 0, BLANK (), totalQuantity )

Best Regards,