Forum Discussion

brettg's avatar
brettg
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
v-frfei-msft's avatar
v-frfei-msft
Community Support
8 years ago

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

  • brettg's avatar
    brettg
    Helper II
    8 years ago

    Hi v-frfei-msft

     

    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

     

  • brettg's avatar
    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