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.
Solved! Go to Solution.
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.
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
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.
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.
@kannanAhammed , hope interactions are not off
You have not used all into the formula used in those visuals
Learn how to create your own user groups today!
Click here to read more about the October 2021 Release!
Check out the new Power Platform Community Connections gallery!
Mark your calendars and join us for our next Power BI Dev Camp!