Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have 2 tables (Transactions & Target), these 2 tables are related to a date table.
When I divide the sum of the [revenue] by the sum of the [target], I get a percentage value
for example: 164 / 630, I get 26%, which is totally fine.
When I try to put that onto a Pie Chart, I get 20% for Revenue & 80% for Target, which is totally fine as well, since Pie Chart represents "part of a whole"
Is there a possibility, that I have a Pie Chart that represents the 26%? which represents the Revenue in comparison to the Target.
Solved! Go to Solution.
Hi HEZZ,
You should know when you put two measure in chart, it will calulate percentage of total value in chart, so you will get 20%(164/(164+630)=20%). So if you want to get correct percentage, you could putthis value in Card or put this value in tooltip in chart to see whether it work or not
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi HEZZ,
You should know when you put two measure in chart, it will calulate percentage of total value in chart, so you will get 20%(164/(164+630)=20%). So if you want to get correct percentage, you could putthis value in Card or put this value in tooltip in chart to see whether it work or not
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Assuming that the #Total revenue to total target% is a measure, just do a new measure:
Other = 1 - [Total revenue to total target%]
Format as percentage and place both measure on your pie chart without any other option filled out on the pie chart.
Should work as expected.
Regards,
MFelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsCovering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |