Displaying Text Value on Zero Values of Bar Chart

[meiwah]

Hi,

I've a bar chart with Net Gearing on y-axis and Year on x-axis. For a zero value of net gearing (y-axis), I would like to display a text value of "Net Cash". Pls kindly help. Thanks! 

[meiwah]

 Thanks! Are u able to let me know your email because I can't attach the sample file?

[Anonymous]

U indeed can't directly link it to here. U may send it to my junk mail
Damianvandenhaak@gmail.com
I will try and find a solution for you. No promises since i personally believe this might not be directly possible.

[Anonymous]

net_gearing =
Var GetNet = SUM(table[column])
Return
If(ISBLANK(GetNet),"Net Cash", GetNet)

[Anonymous]

Displaying a Text message when no data exist in Power BI visual - Power BI Docs
Goodday see above blog about this. This helped me some time back so i had it favorited.

[meiwah]

Thanks for your quick response! The solution is to display text value when there is no data for the entire bar chart. But my intend is to display a text value when there is a zero or blank value for a particular bar 

[Anonymous]

can u send a sample pbix then i will try and replicate a solution for u.