Showing 0 in a graph without showing more than its being filtered

[eduazzolin567]

I have this graph filtered by the year 2022 with some lines stoping at the middle because the rest is blank

I want to show the blank data as zeroes, but if I try something like a measure "if(isblank(value), 0, value)" or "value + 0", power BI brings all the other years and ignores my filter.

[Ritaf1983 · Accepted solution]

Hi @eduazzolin567 

Try to change your X-Axis to continues.

If it won't help attach a link for a dummy file to work with.

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

[Ashish_Mathur · Accepted solution]

Hi,

Does this measure work?

Measure = coalesce([your measure],0)

If not, then share the download link of the PBI file.

[Ritaf1983 · Accepted solution]

Hi @eduazzolin567 

Try to change your X-Axis to continues.

If it won't help attach a link for a dummy file to work with.

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