Is it possible to have collapsible rows (drilldown) in Power KPI Matrix?

[pborah]

The screenshot is from an old SSRS report with sparklines. Below is the one I recreated in Power BI. I was able to replicate the sparklines using the Power KPI matrix, however I'm unable to replicate the drilldown freature even though I have created a heirarchy. The row based metric is only picking up one level of the heirarchy. If I drop the heirarchy to "category", it just adds one more column instead of keeping as collapsible drilldown levels. Thank you.

 

 

[v-yalanwu-msft]

Hi, @pborah ;

Since the Power KPI Matrix is a custom visual object and not built into PowerBI, this is the reason why there is no Drill down.I found some workaround about custom vision and drill.

https://www.reddit.com/r/PowerBI/comments/hjsav0/is_it_possible_to_use_drillthrough_in_a_power_bi/fw...

https://community.powerbi.com/t5/Service/Custom-Visual-with-drill-support/m-p/6753

https://coacervo.co/smlc_200#context-menu-drillthrough--drilldown

I hope it was helpful!

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.