Forum Discussion

wilfredtsk's avatar
wilfredtsk
Helper 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

Anonymous's avatar
Anonymous
Not applicable
8 years ago

wilfredtsk,

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



Regards,
Lydia

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

      Anonymous

       

      Hi Lydia,

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