Rolling Up Dynamic Data

[Anonymous]

Hello, I need to use custom measures to make the chart on the left appear as the chart on the right. The data has to be dynamic. How can I go about rolling this up? Thanks

[PhilipTreacy · Accepted solution]

HI @Anonymous 

Download sample PBIX file

You need to have a category for each item in order to do this.  No need to write measures.

The data can then be summarized in a table like this

Regards

Phil