Forum Discussion

mumair's avatar
mumair
Icon for Helper I rankHelper I
9 years ago

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 di...
Need Help
mumair's avatar
mumair
Icon for Helper I rankHelper I
9 years ago

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?

dkay84_PowerBI's avatar
dkay84_PowerBI
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

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.