cancel
Showing results for
Did you mean:
Helper I

## Exclude a data based on combination of Slicer

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 ?

5 REPLIES 5
Microsoft

Hi @LaurentZ,

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

Best Regards,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper I

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 ?

Microsoft

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,

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper I

Dear

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).

Laurent

Microsoft

Hi Laurent,

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

Best Regards,

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

Announcements