The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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?
Solved! Go to Solution.
Hi @dbhadaur ,
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.
Hi @dbhadaur ,
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.