How to show the line y-axis when there is no data on the y-axis (Line and stacked column chart)?

[anabianco09]

Hi all, I have a conditional column of whole numbers that changes depending on the date (X-axis).

This conditional column is the value I want to show on the Line Y-axis of a line and stacked column chart.  The Column Y-axis is the count of engines for that week.

However, on weeks that I don't have any engines, the line y-axis is cut:

How can I still show the values of the column when something like that happens?

[Anonymous · Accepted solution]

Hi @anabianco09 ,

According to your description, here are my steps you can follow as a solution.

(1) This is my test data. 

(2) Check the box "Show items with no data" and then the result is as follows.

Best Regards,

Neeko Tang

If this post  helps, then please consider Accept it as the solution  to help the other members find it more quickly. 

[MFelix]

Hi @anabianco09 ,

When there is no value what do you want to show the line going to 0?

If yes on the measure you are using for the line just add the +0 on the end of the formula.

[anabianco09]

Hi @MFelix , the line is not a measure, the Line is a column with whole numbers....

I want to show the number that is linked to the dates (which is the X-axis). The number will never be zero.

[MFelix]

Hi @anabianco09 ,

Accordingly to your initial post there are dates where the numbers are blank correct? What do you want to show in those cases?

By default when there is no data the line is break.

[anabianco09]

There are dates that the column Y-axis is zero indeed.

Is there another way for me to show the line when there is no data on the Y-axis?

[MFelix]

Hi @anabianco09,

Sorry for insisting on the question but when there is no data on a specific date what do you want to show?

If this was a chart with continuous axis the line would be filled out connecting all data points since you are using a categorical x-axis the blanks are not filled, for this we need to have some value. Do you want to keep the value from the last date for example?

[anabianco09]

Hi Miguel, I want to still show the line. It represents the capacity on our site. So even if there is no production booked that day (main Y-axis), I still want to show the line (secondary Y-axis).

[MFelix]

@anabianco09 ,

Sorry once again for the question but the column where you are picking up values for the secondaryt axis has values for that specific date?

Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.

If the information is sensitive please share it trough private message.

[anabianco09]

Hi Miguel, thank you so much for the continuous help on this. I tried sending a private message but didn't work. 

I created a database where it would be the same as I have here:

serial_number	capacity	date
sn1	6	01/01/2023
sn2	6	01/02/2023
sn3	6	01/03/2023
-	6	01/04/2023
sn4	4	01/05/2023
sn5	5	01/06/2023
sn6	5	01/07/2023
-	6	01/08/2023

For my chart, I am showing the count of serial numbers by date (column chart, where the X-axis are the date, and the Y- the count). On a secondary Y-axis, as a line, I want to show the capacity level EVEN IF I dont have any serial number for that month.