Forum Discussion

wilfredtsk's avatar
wilfredtsk
Icon for Helper I rankHelper I
8 years ago
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...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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's avatar
wilfredtsk
Icon for Helper I rankHelper I
8 years ago

Hi Lydia,

 

Thank you for replying as always.

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

 

 

Warm Regards,

Wilfred

Anonymous's avatar
Anonymous
Not applicable
8 years ago

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's avatar
    wilfredtsk
    Icon for Helper I rankHelper I
    8 years ago

    Anonymous

     

    Hi Lydia,

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