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
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 ?
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,
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 ?
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,
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
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,
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
108 | |
103 | |
94 | |
71 |
User | Count |
---|---|
173 | |
134 | |
132 | |
101 | |
95 |