Out of 5 slicer selections one visual dont want impact selection the bar chart

[sampathK]

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.

[Anonymous]

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

[sampathK]

Hi @Anonymous ,

    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.

[Anonymous · Accepted 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

[amitchandak]

@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

[sampathK]

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 ?