Stacked bar graph - display 0 for blank or no data.

[NasiraliKarwar]

Hello Community,

I am relatively new to Power BI desktop. I need help with one particular requirement that I came across:

I have a stacked bar graph - In X-axis, I have 4 Quarters: Q1, Q2, Q3 and Q4 and the Y-axis shows a distinct count value. The stacked bar is split by a legend with 2 values: Expired and Pending Expiry.

The table view for the same data:

In the Table view, I can see the value 0 for Q1. But I do not see the same in the Stacked bar graph.

I need to display the 0 in the stacked bar graph when there is no data.

The formula I have used for the count is: 

SKUCount = IF(ISBLANK(DISTINCTCOUNT('Main Table'[SKU])),0,DISTINCTCOUNT('Main Table'[SKU]))

Is there a way to achieve this?

Thanks in advance!

[olgad]

Hi, try adding +0 in the very end of your expression:

SKUCount = IF(ISBLANK(DISTINCTCOUNT('Main Table'[SKU])),0,DISTINCTCOUNT('Main Table'[SKU])) +0

[NasiraliKarwar]

Hello @olgad , Thank you for your suggestion! I tried it, but it still seems to be not working: 

Am I missing something?