cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Why is value 0 not shown in barchart

Hi,

 

I have a barchart with 0-values but the values are not shown...

 

Weirdly enough, when I click on the category in another bar

chart, the 0's appear.

 

I'd like to see those 0's all the time. How can I make that happen?

 

no1.JPGno 0'sno2.JPG0's appear

4 REPLIES 4
Microsoft
Microsoft

Re: Why is value 0 not shown in barchart

Hi Wieke,

 

Can you share a sample file.

 

Regards,

Saurabh

Microsoft
Microsoft

Re: Why is value 0 not shown in barchart

Hi @Anonymous,

 

Click the Refresh button under Home tab to see if it works. What is your current desktop version?

 

Regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Re: Why is value 0 not shown in barchart

@v-yulgu-msft I have the latest version. Still not working...

Veles Advocate IV
Advocate IV

Re: Why is value 0 not shown in barchart

Try adding "- 0" to the end of your measure, or if you're just using a column make a measure of it like this:

 

Measure = SUM ( 'Table'[Column] ) - 0

 

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

Top Solution Authors
Top Kudoed Authors