Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Cbutler
Helper III
Helper III

Slicer is filtering but my table isn't filtering the values?

Hi there, 

I have a slicer that if I use filters all the values across all my tables correctly, but in the Table/Matrix visuals if I select the same item as in the slicer the table filters all the other visuals to 000/blank? 

Is there something obvious I am missing here? Its never happened to me before? I have used a crossjoin table, could that be the issue? 

Filtered by slicer

Cbutler_0-1598009271173.png


Filtered by table

Cbutler_1-1598009309221.png


Any advice would be appricated 🙂 

 

4 REPLIES 4
v-easonf-msft
Community Support
Community Support

Hi, @Cbutler 

If nothing is selected in "Table\matrix" or in slicer,does the table still  filter all the other visuals to 000/blank?

And please check if there any other filters appled in this visual right now.

207.png

 

It will be better if you can share a sample file  without  any sensitive data  .

 

Best Regards,
Community Support Team _ Eason

pranit828
Community Champion
Community Champion

HI @Cbutler 

Check the intractions between slicer and the table.

Select the slicer and go to Format menu option and click interactions.

On right top of your table, you will see some icons pop up, Select the lsft or eh middle icon.

This should resolve your issue.





PBI_SuperUser_Rank@1x.png


Hope it resolves your issue? 
Did I answer your question? Mark my post as a solution!

Appreciate your Kudos, Press the thumbs up button!!
Linkedin Profile
amitchandak
Super User
Super User

@Cbutler , table seems to be filtering the visual?

Otherwise, the interaction or measure with all could be an issue

https://docs.microsoft.com/en-us/power-bi/create-reports/service-reports-visual-interactions

Greg_Deckler
Super User
Super User

@Cbutler - It's difficult to tell what is going on. Is there a measure for that bar chart? If so, what is the formula? Can you post the PBIX or sample data?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.