Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Multiple Value in Data Label format for Clustered column chart

Hello All,

 

I have created a clustered column chart for my data and I have added percentage of two different category A & B (for example) in measure A1 and B1 resepectively

In the Visuals of Clustered column chart I have added A and B in Y axis and in X axis I have added the value which I want to show against Categories.

But when I am trying to add percentage which is stored in A1 and B1 Measures, I am able to add only one value in Data Labels.

I want to show percentage for both A and B Category separately so I want to add both A1 and B1 in "Add data" but aparantely I can add only one

Can someone help to resolve this issue?

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous ,

    Data Label can only add one Value, by design. If you want to add separate Data Labels for A and B, then you can't use measure to calculate for A and B separately and then put them into the chart.
    Here is my sample data:

    I use this DAX to create a measure:

    Measure = 
VAR _SUM =
CALCULATE(
    SUM('Table'[Value]),
    ALLEXCEPT('Table', 'Table'[Category])
)
RETURN
DIVIDE(MAX('Table'[Value]), _SUM)

    Then create the clustered column chart, put the Category into the Legend:

    After that, then I add the data label, and the final output is as below:

     

    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    Data Label can only add one Value, by design. If you want to add separate Data Labels for A and B, then you can't use measure to calculate for A and B separately and then put them into the chart.
    Here is my sample data:

    I use this DAX to create a measure:

    Measure = 
VAR _SUM =
CALCULATE(
    SUM('Table'[Value]),
    ALLEXCEPT('Table', 'Table'[Category])
)
RETURN
DIVIDE(MAX('Table'[Value]), _SUM)

    Then create the clustered column chart, put the Category into the Legend:

    After that, then I add the data label, and the final output is as below:

     

    Best Regards,
    Dino Tao
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.