Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I feel like this is either incredibly simple or downright impossible. I grabbed the below image off Google, but it's basically what I have. Is there a way to display the exact amount of the entire column? So far, all data labels only display the amount of the individual pieces making up the column.
Solved! Go to Solution.
Hi @Anonymous,
For stacked column chart, we only can display the individual amount. You can use line and stacked column chart. You can create a measure using the following formula, and add it as line values.
amount=CALCULATE(SUM(Table[value]))
For example, I create the following sample table.
Create measure using the formula: Measure11 = COUNTA(Table1[physicians]), then add it as line values.
Best Regards,
Angelia
Hi @Anonymous,
For stacked column chart, we only can display the individual amount. You can use line and stacked column chart. You can create a measure using the following formula, and add it as line values.
amount=CALCULATE(SUM(Table[value]))
For example, I create the following sample table.
Create measure using the formula: Measure11 = COUNTA(Table1[physicians]), then add it as line values.
Best Regards,
Angelia
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 39 | |
| 37 | |
| 33 | |
| 32 | |
| 29 |
| User | Count |
|---|---|
| 132 | |
| 88 | |
| 82 | |
| 68 | |
| 64 |