histogram : color each terms before summation

[vadim_g]

hello,

it seems very simple, but i really don't knwo how to do this...

I have this data :

In powerbi i can do this (really simple) :

but i want this (if the merge by name contains several terms of duration (as the name C3) each terms of supbart before summation must have a different color) :

Thanks a lot (and sorry for my english if you dont understand).

[mahoneypat · Accepted solution]

In your query, you can add a subgroup index column and then use it as the legend in your visual (you can then hide the legend as it won't have any meaning).  See article for how to do it.

Create Row Number for Each Group in Power BI using Power Query - RADACAD

Pat

[vadim_g]

genial =D i accept your solution !