cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kannanAhammed
Helper IV
Helper IV

Slicer is not working for certain visualizations

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.

1 ACCEPTED SOLUTION
Pragati11
Super User
Super User

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


My Blog: Data Vibe
Connect: LinkedIn
Connect: Twitter






If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




View solution in original post

9 REPLIES 9
FarhanAhmed
Super User
Super User

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.







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




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

kannanAhammed_0-1597744952718.png

 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.







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




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


My Blog: Data Vibe
Connect: LinkedIn
Connect: Twitter






If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




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

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


My Blog: Data Vibe
Connect: LinkedIn
Connect: Twitter






If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




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


My Blog: Data Vibe
Connect: LinkedIn
Connect: Twitter






If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




amitchandak
Super User
Super User

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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin

Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
Pragati11
Super User
Super User

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


My Blog: Data Vibe
Connect: LinkedIn
Connect: Twitter






If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!