Urgent : Bar Chart Line is not displaying if there is no data.

[mg00842082]

Hi All.

In Bar Chart pink line y - axis is not displaying for the date 8/25/24 if there is no data.

I want to display Pink line in this chart if there is no data it will show as '0' by not showing as below screenshot.

(Note : Pink line should be cut it will cover all the bars in the chart)

Regards,

krishna.

[SamWiseOwl · Accepted solution]

Hi @mg00842082 

Create a measure or modifiy your existing measure.

Show 0 =
IF(
IsBlank([Your Calculation])

,0

,[Your Calculation]
)

Use this in your visual 🙂

[v-xiaocliu-msft · Accepted solution]

Hi @mg00842082 ,

Have a good day. Have you solved the problem?

I followed @SamWiseOwl 's solution and it worked.

Here are the detailed steps.

If this helps, please consider mark @mg00842082 's solution.

Best Regards,

Wearsky

[SamWiseOwl]

Which bit isn't working?

1. Making the measure
2. Putting the measure in the visual (Line section)
3. Remove the old field

[SamWiseOwl · Accepted solution]

Hi @mg00842082 

Create a measure or modifiy your existing measure.

Show 0 =
IF(
IsBlank([Your Calculation])

,0

,[Your Calculation]
)

Use this in your visual 🙂

[mg00842082]

Hi @SamWiseOwl - it is not working can you please tell where to update in filters?