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

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
    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!