Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi All,
In my image below I have two tables. The bottom tables shows all results between the given date range. The top table shows each individual users latest result between the date range.
Using the top table, I would like a pie chart to show the count of 'Latest Grade', so 2 for Medium & 1 for High.
However, I can't seem to add my measures to the pie chart visual to show the data in this way. Would anyone be able to help with this?
Thanks in advance,
Brett
Hi @brettg,
As we know, measures could not be added to visual as column, Could you please share you pbix and your excepted result to me. So that I can have a check whether is there any other way to work around?
Regards,
Frank
Thanks for looking into this for me.
I have attached my pbix file to the following link https://www.justbeamit.com/9pg9g
I would just like a Pie chart which shows the count of 'Latest Grade' for each individual users latest test. I have got this to work in table format, but it would be really helpful in a Pie chart. I'm guessing I will need some measures that act as visual filterts?
Thanks for your help!
Brett
Hi @brettg,
I got this error message, Could you please share again?
Regards,
Frank
Hi @brettg,
Based on my test, I think here we can use tooltips to work around.
For more details, please check the pbix as attached.
https://www.dropbox.com/s/ndahgk5ez8py72y/latest%20result%20temp.pbix?dl=0
Regards,
Frank
Thanks for your help! So close..
I would like to use 'Grade' as the legend, so it counts the users in 'High' & 'Medium'
When I switch the legend to 'Grade' it's not working though, is it only possible to show the user as the legend?
Thanks,
Brett
Hi @brettg,
Based on my test using your data, Yes, it is only possible to show the user as the legend currently.
Regards,
Frank
Thanks for the time you spent looking at my issue. I guess I need to see if I can get a distinct user measure to add as a tool tip. If I can manage that it should only show 1 test per user.
Thanks,
Brett
Thanks for looking into this for me.
I uploaded my pbix file to the following link - https://files.fm/u/pma3m6dq
I would just like a Pie chart which shows the count of 'Latest Grade' for each individual users latest test. I have got this to work in table format, but would be really helpful in a pie chart. I'm guessing it will need measures that act as visual filters?
Thanks for your help!
Brett
User | Count |
---|---|
130 | |
108 | |
101 | |
67 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |