Can we show only 0 when no data is available to di...

sdhn · ‎11-02-2023

Hello All,

I have a reprt , i am comparing two fiscal years.

There is no data in one fiscal year.

So it is not showing graph or data corrcetly.

can we show only 0 when no data is available to display.?

Thanks

Greg_Deckler · ‎11-02-2023

@sdhn Try adding +0 to your measure at the end. So like:

Measure = SUM('Table'[Value]) + 0

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Can we show only 0 when no data is available to display.?