Forum Discussion

Regular Visitor

7 months ago

Solved

Reverse Slicer not showing all data

Hello Everyone,

I created a Reverse Slicer logic based on disconnected table. it's working fine in terms of excluding the values I select. However, not all values that should be shown are being displayed.

My sample data and PBIX are in this link (Reverse Slicer Zip).

Appreciate the help.

HRegnum
7 months ago
I found out why. I missed that these entries fall under a different category of Hours.
Got fuzzy from looking too much at it.

5 Replies

danextian
Super User
7 months ago
Hi HRegnum

By default Power BI excludes rows where measures return blank. You can force Power BI to return 0 for blank rows or simply check show itesm with no data.
- HRegnum
  Regular Visitor
  7 months ago
  I found out why. I missed that these entries fall under a different category of Hours.
  Got fuzzy from looking too much at it.
  - v-menakakota
    Community Support
    7 months ago
    Hi HRegnum ,
    Thanks for reaching out to the Microsoft fabric community forum.
    
    I hope you found the solution thank you for the update
    
    Best Regards,
    Community Support Team
- HRegnum
  Regular Visitor
  7 months ago
  hi @danextian, I am aware of the option.
  If you look at the data you can see "Testing" and "User Training" have values in the matrix table, yet I can't see them in the bar chart for the "Engineering" organisation.
  for the other organisation entry "External Vendor A", we can see all values that should appear (they are 2 in total and both shown, contrary to Engineering).
  
  Thanks.

Related content