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 am trying to do a simple visualization with the average of each of the values for each attribute. I noticed that when I filter my data for working with individuals, the total is 5.4 and dividing that by 18, I should show 30% and my visual is showing 18%? Can you see what I may be doing incorrectly?
Hi @jcastr02 ,
You are using stacked bar chart visual according to the screenshot you provided , where the average value are calculated by dividing the total value of each category by the amount of that category. For example , calculate the average value of "working with individuals" data in your scenario , the total value of this category is 5.4 , assuming that the amount of this category is 18 , then the average value should be 0.3 (5.4/18 ) . As for why the value you got is incorrect , I'm not sure if is caused by the data or some filters applied affect the calculation result . If it is convenient , could you please provide your PBIX file with sample data ?
Best Regards
Rena
Is it dividing by the entire list of sttributes rather than just the one you have selected?
Hmm is it just me or are you having 22 rows? Manually calculating results in an average value of 0.2454 so I expect there is something other funny business going on in your dataset. I see for example a lot of errors in you Value column?
Is it possible to share your pbix? (you can share via PM if you don't want to share publicly).
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
Proud to be a Super User!
Covering 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 |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |