Displaying data label (x-axis) for a clustered column chart when there is zero value

[wilfredtsk]

Hi experts,

I am trying to "display" the data label of my graph where there is no data...

[reference to my graph, I have a subject-science of which no one achieve a quality pass (after my measure)]

How do I still keep that label on?

Thank you for your attention!

Cheers,

wilfredtsk

[v-yuezhe-msft]

@wilfredtsk,

I am not quite sure what is your expected result. How about you turn on data label.



Regards,
Lydia

[wilfredtsk]

Hi Lydia,

Thank you for replying as always.

Here's my expected results..., i.e. showing that "Fdn Science"....

Warm Regards,

Wilfred

[v-yuezhe-msft · Accepted solution]

@wilfredtsk,

Do you have the "Fdn Science" value in your table?  Does you measure return blank value for the "Fdn Science" category? If so, create a new measure using DAX below, drag this new measure to the column chart and turn on data label.

NewMeasure= if(isblank([Measure]),0,[Measure])

Regards,

Lydia

[wilfredtsk]

@v-yuezhe-msft

Hi Lydia,

Wow! You are always awesome. Yes! It works. Thank you so much!