Forum Discussion
Solved
Displaying data label (x-axis) for a clustered column chart when there is zero value
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 measur...
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,
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
Anonymous
Hi Lydia,
Wow! You are always awesome. Yes! It works. Thank you so much!