cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
baxter2_nois102
Frequent Visitor

Qlik to Power BI Chart

Hi all,

 

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

baxter2_nois102_0-1627917246028.png

 

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!

1 ACCEPTED SOLUTION
v-jingzhang
Community Support
Community Support

Hi @baxter2_nois102 

 

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

080401.jpg

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.

View solution in original post

3 REPLIES 3
v-jingzhang
Community Support
Community Support

Hi @baxter2_nois102 

 

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

080401.jpg

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.

View solution in original post

mahoneypat
Super User
Super User

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





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about Power BI, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Pragati11
Super User
Super User

Hi @baxter2_nois102 ,

 

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


My Blog: Data Vibe
Connect: LinkedIn
Connect: Twitter






If this helps, Appreciate a KUDOS!
Did I answer your question? Mark my post as a solution!


Proud to be a Super User!




Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!