"Show items with no data" is not working in line chart, expect in tables

[Clout]

Hello guys,

In some columns of my data the first months are blank, but in the other columns the data exists in these first months.

When I visualise the data with the first blank rows in a chart, the date axis starts with the first existing data. But when I put my date slicer at the beginning of the database, I want to show the blank data in the visual too.

So I think this works with "Show items with no data" and it works with a table. But it doesnt work with line chart:

As you can see, the blank rows are displayed in the table, but not in the line chart. The line chart begins at the 1th January 2021, but I put the slicer at the end of 2019. I want to show the date axis like in the left chart "mittlere O2-Konz. in ml/l"

Trough my google research, it should be possible with "show items with no data". But somehow it doesnt work in my dashboard with any data.

Thanks in advance!

[v-lionel-msft · Accepted solution]

Hi @Clout ,

If you change the type of the x-axis to "categorical" and enable 'Show items with no data' option, you can see the blank values.

Best regards,
Lionel Chen

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

[Clout]

Okay thank you, so I think its not possible another way.

[amitchandak]

@Clout , Try a measure with +0 and check

new measure  = [Measure]+0

Can you share a sample pbix after removing sensitive data.

[FlankyPank2___]

Thank you amitchandak - just added +0 to my measure and the magic happened 🙂

[Clout]

Thank you for your answer @amitchandak 

Now it will show me the whole time, but now it looks like that too:

Is it possible to hide the line which is 0?