Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hello Team,
I have 3 slicers like Country name, State Name, Region Name and one bar chart to total sales, Total Revenue, Total Profit measures.
Problem statement:-
When we select Country Name, Region Name Total sales should show what values it has in data set but when we select State Name Total Sales should not filter on this. Total Sales shoudnt reflect when we select State Name slicer in report.
Any idea or suggestions please let me know.
Thank you.
Solved! Go to Solution.
Hi @sampathK,
Currently you can't direct configure the filter effect with measure formulas, perhaps you can try to add all functions to your formula to only respond with a filter on specific fields.
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT
Notice: dax formula not able to extract different filter result from the filter who used the same data source fields.
Regards,
Xiaoxin Sheng
Hi @sampathK,
It sounds like you want to achieve cascade filter effects on the slicers.
AFAIK, current power bi filters not use the same logic as the cascade filter did. Perhaps you can turn on the interactions UI to configure the slicer integrations(slicer 1-> slicer 2, slicer 2 -> slicer 3) to achieve a similar effect.
Change how visuals interact in a Power BI report
Regards,
Xiaoxin Sheng
Hi @v-shex-msft ,
When i select one option in slicer it should reflect two measures in other visual and should not reflect 3rd measure in same visual. I trying to disable interactions for only one measure and other two measures should reflect as slicer selection.
The third measure should reflect when second slicer selection happens. If i try to remove interactions it will remove all the measures but i dont want this. I want remove interactions from slicer to particular measure only i need.
Hi @sampathK,
Currently you can't direct configure the filter effect with measure formulas, perhaps you can try to add all functions to your formula to only respond with a filter on specific fields.
Managing “all” functions in DAX: ALL, ALLSELECTED, ALLNOBLANKROW, ALLEXCEPT
Notice: dax formula not able to extract different filter result from the filter who used the same data source fields.
Regards,
Xiaoxin Sheng
@sampathK , if you do not want to use the slicer on visual you can disable interactions
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions
Hello amitchandak
I dont want to remove Interactions because it will reflect other two measures Total Revenue and Total Profit . I dont want do that by using dax can we get it directly ?
User | Count |
---|---|
128 | |
108 | |
100 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |