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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Jess_Scragg
Frequent Visitor

Keep all categories Power Bi Slicer

I am adding a slicer to my dashboard and want all categories to remain in the visuals when the slicer is applied. For example, one of my visuals is a line and stacked column chart which has a count of values for different categories, as below:

Jess_Scragg_1-1663061323210.png

 

Some of these "value bins" have no entries on some of the groups I am slicing my data by. For example, if I click "Group A" on the slicer, the value bin of £7k-£9,999 disappears because there's no values here. I don't want this to happen - I want this to remain on the x axis and it to just showing as a blank / non-existent column. I want it to be clear there's no entries there. Otherwise, if it just disappears, this is misleading.

 

Any help on how to do this please?

2 REPLIES 2
amitchandak
Super User
Super User

@Jess_Scragg , Try this option with groups - Show Items with no data (Right in visual pane on group)

 

ShowItemwithoutdata.JPG

 

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Hi - this is selected with a tick, but they still disappear

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.