Forum Discussion
Play Axis - Show aggregate when looping?
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!
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-dataRegards,
Charlie Liao
1 Reply
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-dataRegards,
Charlie Liao