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
toniacheung
Frequent Visitor

broken line with no data on line & stacked column chart

powerbi question.png

 

I have a line and stacked bar chart for months over the course of a year.  There are some months where the column value is zero, so by default Power BI removes those columns.  I wanted to have all the months on teh chart, so selected to show data with no value, but now the lines on the chart are broken.  Is there any way to get Power BI to connect them?

 

 

 

 

 

 

5 REPLIES 5
mussaenda
Super User
Super User

At the end of your measure code, put +0 to avoid broken lines

powerbi question2.png

 

Both solutions--the new measure and just adding +0 at the end of my formula--worked to make a continuous line.  However, I want it to ignore the 0s.  The yellow line is supposed to be a target.  The formula (after adding the +0 to keep the line connected) is MAX([column with target values for different departments])+0.  This should stay consistent over the entire year, not drop to 0 in those months.  The red line is supposed to be cumulative number over the year.  The formula for it is CALCULATE(COUNTA('Table'[Date], FILTER(ALL('Table', ISONORAFTER('Table'[Date], MAX('Table'[Date], DESC)))+0.  Again, since it is cumulative, the line shouldn't drop to 0 when we have no data for a month, it should just stay consistent until we have new value to add on to the running total.  How do I get that?

Thank, my cumulative sum line formula that I put above works fine except when I have months where the value is 0.  It's not a sum, it's a count of entries.  I just need it to ignore when a month has 0 entries and connect the previous month to the next without dipping down to 0.

evandrocunico
Resolver III
Resolver III

HI @toniacheung maybe set zero to measure instead blank.

 

New measure  = if(measure is blank();0;measure)

 

regards.

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.