Forum Discussion

Helper II

8 years ago

Measures in visuals

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. ...

Need Help

brettg

Helper II

8 years ago

Hi v-frfei-msft

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

v-frfei-msft

Community Support

8 years ago

Hi brettg,

I got this error message, Could you please share again?

Regards,

Frank

brettg
Helper II
8 years ago
Hi v-frfei-msft

Sorry about that, try this link? https://files.fm/u/pma3m6dq
brettg
Helper II
8 years ago
Hi v-frfei-msft

Sorry about that! Try this link https://www.justbeamit.com/ykds4
- v-frfei-msft
  Community Support
  8 years ago
  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
  - brettg
    Helper II
    8 years ago
    Hi v-frfei-msft
    
    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

Forum Discussion

Measures in visuals

Related content

How to show multiple metrics/measures in a visual?

Measure Issue in visual table

Measure

Table visual with data from Data tab + measures

Measure breaks visual