cancel
Showing results for 
Search instead for 
Did you mean: 
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
Microsoft

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
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors