Qlik to Power BI Chart

[Anonymous]

Hi all,

I am new in PBI and I am migrating a QlikView dashboard to PBI, and I am dealing with one chart:

is there a way to create something similar in PBI?, as you can see it like a Parent table with Child tables or a summary table, ann the "child" tables have a different metric.

Any suggestion?

Regards!

[v-jingzhang · Accepted solution]

Hi @Anonymous 

You can use Matrix visual to get a similar result in Power BI. I attach a sample file for your reference.

Reference: 7 Secrets of the Matrix Visual 

Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.

[mahoneypat]

I believe you could make that with a Matrix visual with the same two columns in the Columns field across the top (Month and CF/LP/Total) , your 2 or 3 columns on rows, and a SWITCH measure that changes the calculation/expression based on the SELECTED VALUE of your parent row column (SIN ASSIGNACION, INTERCOMPANIAS, etc.).  It could also be done with Calculation Groups.  Either way, probably not the easiest first thing to do in Power BI if you are learning, but it's doable.

Pat

[Pragati11]

Hi @Anonymous ,

First thing I don't understand the Parent-Child table scenario in your screenshot.

But looking at the screenshot, you can use matrix visual in Power BI to achieve this similar.

Thanks,

Pragati