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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Display "0" value in chart

Hi,

pbi1.png

 

I have a clustered column chart that display monthly data, however some data are not yet being input. I'd like those empty month to show the value 0. Something like this :

pbi2.png

 

Is there any solution to this? 

 

 

 

 

 

 

1 ACCEPTED SOLUTION
arvindsingh802
Super User
Super User

You have to define that in your measure, considering you are taking sum in columnA and want to show 0 when its blank
Measure = IF(ISBLANK(Sum(columnA)), 0, Sum(columnA))

 

If this post helps, then please consider Accept it as the solution and give it a thumbs up


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

View solution in original post

1 REPLY 1
arvindsingh802
Super User
Super User

You have to define that in your measure, considering you are taking sum in columnA and want to show 0 when its blank
Measure = IF(ISBLANK(Sum(columnA)), 0, Sum(columnA))

 

If this post helps, then please consider Accept it as the solution and give it a thumbs up


If this post helps, then please consider Accept it as the solution, Appreciate your Kudos!!
Proud to be a Super User!!

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors