Stacked Column chart with rows

[Anonymous]

Hello everyone,

I've got stuck with one visual.

I need to represent how much transition employee has done. To show this we used column chart with rows (as a matrix), but as I understand there is no standard solution in Power BI to do this. The Nearest to the truth is Stacked Column Chart by Akvelon.   https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104381825?tab=overview

But it has one big issue  - somehow it cant recognize the Date hierarchy and I can't drill-through date, it's must for us.

Maybe someone from this group have made similar visual and have to suggest more efficient solution?

There is sample pbix:

https://drive.google.com/file/d/1lIEPCRrfzZEaF0cu9VRAJYhbX_NpWXn5/view?usp=sharing

[amitchandak]

@Anonymous , There is a feature released recently small multiples - see if that can help

https://www.youtube.com/watch?v=a7PIApvjmVw

[Anonymous]

Hi, @amitchandak ,

I tried it, but it won't work, because it gives just visuals in matrix.

If I choose to show one column  I can have just 6 rows, for this case I need 20 😞