cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Slicers not affecting certain tables?

I am trying to create a dashboard, and I am using slicers to manipulate the data. However, there is one table that my slicers won't affect. This is confusing me because all of my tables are either directly or indirectly linked. The table that is not affected was a created table, so I am wondering if this would have any effect?

5 REPLIES 5
Highlighted
Memorable Member
Memorable Member

let's clarify; we're in Desktop forum so we're discussing a report - rather than a dashboard I will presume since dashboards are in Service.

 

You have a slicer on the same page as another visual - and when selecting values in the slicer, the visual is not changing?  that is my interpretation of your post.

 

I would delete the slicer, and re-add it as a quick sanity check; but assuming the behavior is the same it means the data set in the visual is not being affected by the filtering of the slicer even though you say the tables are related.  A guess is the impact/result of another table's join is the reason. 

 

Rather than use a separate table for the slicer content - can you use the field of the dataset in the visual directly as your slicer source.  Sometimes this is possible depending on the data structure.

 

Another thing you could do is make a copy of your pbix - and delete the joins of those other tables and experiment that way.  This would free up the impact and verify that it works in a simpler set up.  Not the final answer of course but possibly the path to understanding.

www.CahabaData.com
Highlighted

Also make sure you have bidirectional cross filter turned on as it may be an issue with how the filter flows.
Highlighted

Correct, I am using Power BI Desktop to create a report. I only called it a dashboard because I am trying to display key performance metrics.

 

Deleted the slicers and readded them and they still do not work.

 

Can't use the field in the visual as the slicer because of the data structure.

 

The bidirectional filter is also turned on.

 

Any other ideas or thoughts?

Highlighted

Do the nonfunctioning slicers rely on an inactive relationship?  If so, see if changing that relationship to Active solves the problem.  If this is not the problem, then there is likely something wrong with your data model or underlying data.  Please share your pbix file (scrubbed for any sensitive data) if you want.

Highlighted

I have had slicers not perform as I expected - not due to a bug, but because the joins between tables can affect the definition of the data set.  So as noted in the last paragraph of my first post; what I would do at this point is make a copy of your pbix - and delete the joins of those other tables and experiment that way.  This would free up the impact and verify that it works in a simpler set up.  Not the final answer of course but possibly the path to understanding.

www.CahabaData.com

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors