I have many independent tables but are conneted to "1 to many" relationsip with a master table. I have added a field from this master table as the slider field. it works fine for most visulizations except 2, I have added same field with values on both dataset associated with the 2 visualizations and set relationship as 1 to many.

Hi Anonymous , The information is not sufficient to answer your question. Please share some screesnhots on your data model relationships, the visuals and how slicers are behaving. Thanks, Pragati

Slicer is not working for certain visualizations

9 Replies

Pragati11
Super User
6 years ago
Hi Anonymous ,

The information is not sufficient to answer your question.

Please share some screesnhots on your data model relationships, the visuals and how slicers are behaving.

Thanks,

Pragati
amitchandak
Super User
6 years ago
Anonymous , hope interactions are not off
https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

You have not used all into the formula used in those visuals

calculate([Measure], all(Table))
FarhanAhmed
Community Champion
6 years ago
If possible can you please share some screenshot on which visuals problems are occuring.

Also if possible share the screenshot of your Data Model?
Dimensions can Filter data of tables where they are directly connected to. If any table which is indirectly connected to Dimension will not be filtered unless you use explicit Cross Filter or create measure to use Cross filters.
- Anonymous
  Not applicable
  6 years ago
  Hi All, Thanks for the Responce.
  
  please see the data model the RFS number of EMROther has 1 to many relationship with RFS number of other tables.
  
  Please see the data model
  the one which has this all the visuals other than
  - FarhanAhmed
    Community Champion
    6 years ago
    Any Filters from "MER" will not change "HSE Assesment" & "Top Quality"
    Similarly "HSE Assesment" wont change "MER" & "Top Quality" & Vice versa
    
    If you see the direction of arrows you will see the that when you made selection of field it will impact on which side, if you are selecting MER field then it will not have any impact on "MEROhter" table unless you use filter from MEROther that will impact on MER table.