Display Zeros on Graphic bars with no Records

[LuisPlaza101]

I have a Grapth bar in which when ever is Zero the grand total display Zero as Total .   Any advice how to accomplish 

A Zero should be as total of that X Field. 

[v-nmadadi-msft]

Hi @LuisPlaza101 ,

As we haven’t heard back from you, we wanted to kindly follow up to check if you are able to provide more details regarding your query. Please feel free to contact us if you have any further questions.

Thanks and regards

[Praful_Potphode]

Hi @LuisPlaza101 

Please provide more information.

[v-nmadadi-msft]

Hi @LuisPlaza101 

May I check if this issue has been resolved or if you got the chance to provide some more details regarding your issue? If not, Please feel free to contact us if you have any further questions.

Thank you

[v-nmadadi-msft]

Hi @LuisPlaza101 

I wanted to check if you had the opportunity to review the information provided and got the chance to provide some more details regarding your issue. Please feel free to contact us if you have any further questions.

Thank you.

[Nabha-Ahmed]

• He Hi @LuisPlaza101

This usually happens because the measure returns blank() instead of an actual 0 value.

Try updating your DAX measure like this:

 

MyMeasure =
IF(ISBLANK(SUM('Table'[Column])), 0, SUM('Table'[Column]))

Thanks✨🌹

Put kudo ✨

[v-nmadadi-msft · Accepted solution]

Hi @LuisPlaza101 ,
Thanks for reaching out to the Microsoft fabric community forum.


The question isn’t entirely clear at the moment. Could you please clarify exactly what you’re trying to achieve? That will make it easier for us to review and suggest a possible solution. In the meantime, you might also find this forum post useful  it shares some tips on how to structure your questions so you can get faster and more accurate answers.

Re: How to Get Your Question Answered Quickly - Page 4 - Microsoft Fabric Community

Thank you

[FBergamaschi]

Hi @LuisPlaza101 

I am confused on what you are asking, can you please explain better and show good images?