Forum Discussion
Helper IExclude 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
v-jiascu-msftMicrosoft 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,
LaurentZHere 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,