Slicer is not working for certain visualizations

[kannanAhammed]

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.

[FarhanAhmed]

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.

[kannanAhammed]

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]

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.

[Pragati11]

Hi @kannanAhammed ,

This looks more like a data issue to me as one you select BLANK on your filter, the visuals reflect the changes.

Try replacing BLANK values in the column used as a slicer, with some value like "Not Mapped", "Not Available", etc.

Thanks,

Pragati

[kannanAhammed]

Yes it was a data issue i ve changed it, now its working. 

[Pragati11]

Hi @kannanAhammed ,

If this is a data issue thing and it resolved your problem by modifying your data, please mark this right comment as an answer to the thread. This will just help others to see the right solution.

Thanks,

Pragati

[Pragati11]

Hi @kannanAhammed ,

In addition to your data model relationship screesnhot, can you add your visuals screenshots as well along with what slicers are used and how they are behaving?

Thanks,

Pragati

[amitchandak]

@kannanAhammed , 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))

[Pragati11 · Accepted solution]

Hi @kannanAhammed ,

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