Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
LaurentZ
Helper I
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
v-jiascu-msft
Microsoft Employee
Microsoft Employee

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,

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.

Here is a very simplified exemple:

 

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

 

b0e396446a8ddb2f50e30bea435936e3.jpg

 

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.

 

40509612acc84f1cd9758cf661e224b9.jpg

 

Is it Possible ?

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.

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

 

Link: pbix

 

Laurent

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 )

Exclude-a-data-based-on-combination-of-Slicer

 

 

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.

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.