Forum Discussion

jseow's avatar
jseow
Frequent Visitor
8 years ago
Solved

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 t...
  • v-caliao-msft's avatar
    8 years ago

    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