Reply
Markzolotoy
Impactful Individual
Impactful Individual
Partially syndicated - Outbound

Stacked chart - always show zeros

Let's say I have a stacked chart that shows two categories. When one category's value is zero it is not shown in the chart. Can I enforce it to show all the time?

 

Thanks

7 REPLIES 7
Markzolotoy
Impactful Individual
Impactful Individual

Syndicated - Outbound

@serpiva64 Ah, I see it now. You are applying it to the Y axis. But for me it is available for X axis.

Markzolotoy
Impactful Individual
Impactful Individual

Syndicated - Outbound

@serpiva64 I dont see that option. The value is shown as Sum. Is that he reason?

serpiva64
Solution Sage
Solution Sage

Syndicated - Outbound

Hi,

have you tried to "show items with no data"?

serpiva64_0-1671793541962.png

 

ouaelaam
Resolver I
Resolver I

Syndicated - Outbound

You can use a measure like this :
IF(

ISBLANK( [Value] ),0,
[Value]
)

Syndicated - Outbound

@ouaelaam The value is not really blank, it is numeric zero.

Syndicated - Outbound

You can try to replace 0 with a very small value like 0.00001.

Syndicated - Outbound

@ouaelaam Nope.

avatar user

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)