Forum Discussion

NewPBIe's avatar
NewPBIe
Icon for Helper II rankHelper II
3 years ago

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.  

 

 

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    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!