Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have a table visual and a pie chart visual. When I have 4 rows in the table, the pie chart does not display values correctly. When I select 1 row in the table, the pie chart displays correctly. What am I doing wrong?
Here is Table with 4 Rows and Pie chart:
The Pie chart visual currently does not supply the average for the 4 columns in the table. It should be as follows:
ED Needed: (1%) Should be 17%
ED Preventable: (0%) Should be 6%
PC Treatable: (12%) Should be 16%
Non Emergent: (1%) Should be 12%
When I click on an individual row, the pie displays correctly:
What am I doing wrong? I am using Average for the Pie Chart Values?
Also, How do I keep 0 value labels off of the pie chart? (For example above, I really don't want ED Needed (0% to show on the Pie). I can live with that little nuance though.
Thank you in advance for your help.
Solved! Go to Solution.
I finally solved the problem by embedding adding the 4 ED Acuity fields into the primary table for each row. It works now as expected. It must have been a wonky join, or I needed to do some calculation. Thank you for responding.
hello @vstopp
Not sure how much I can help, but first , could you show a picture of your data tables, it could be an issue with summation, or averageing
I finally solved the problem by embedding adding the 4 ED Acuity fields into the primary table for each row. It works now as expected. It must have been a wonky join, or I needed to do some calculation. Thank you for responding.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |