Play Axis - Show aggregate when looping?

[jseow]

Hi all,

I am currently trying to use the Play Axis visualization (imported from store) for a wall display of a dashboard. It loops through a categorical variable perfectly, but is there any way to have it include the aggregate view in the loop? For example, currently I have three categories, it will loop through A, B, then C. What I would like is it to loop through A/B/C, A, B, then C. 

If anyone has knows how to do that, or can suggest an alternate custom visualization with this feature, it would be greatly appreciated!

Thanks!

[v-caliao-msft · Accepted solution]

@jseow,

What I would like is it to loop through A/B/C, A, B, then C. 

If you want to show the aggregate value A/B/C when looping, you could add the category name A/B/C in your data table. Create a table to show the category A/B/C and the aggregate value, then append this new created table to your original table.
https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data

Regards,

Charlie Liao