Forum Discussion

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 measure)]

How do I still keep that label on?

Thank you for your attention!

Cheers,

wilfredtsk

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

4 Replies

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

Related content