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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
NewPBIe
Helper II
Helper II

Bar chart loose some bars while filtering

Hallo everybody, 

 

I've got a Bar chart to show count of 6 different categories. 

If I select a filter, the visual will only show the bars with some data on it. 

 

I need to keep the bars also if they are empty. 

 

Show elements without data doesn't work, since is shows a seventh bar that i dont need.  

 

 

1 REPLY 1
Anonymous
Not applicable

Hi @NewPBIe .
Does it work to simply add + 0 with your count or sum measure. I.E

Sum('Table'[Count]) + 0 
 
If not, please provide sample file.
 
Thanks!

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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