Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
Gopal_PV
Helper III
Helper III

How to display view table data in matrix report in power bi

Hi Friends,

I am connecting power bi from snowflake views. i have multiple views being linclude  with diffrent logic.

Below is the view input data.

 

I want to load and get below out put in PBI. Sum of Units :BoP,New,Exapansion,Contraction,Churn, EoP. 
What is the best way to this. I need exactly same as below. How to BoP as Same sort order.
What is the best approach if i have same kind of views for Payment,Suscription,Screeing .

Gopal_PV_0-1753987748638.png

Gopal_PV_1-1753987940124.png

 


Input VIEW.

 

    Units View       
YEARMONTHACCOUNTIDNAMEBEGINNING_OF_PERIOD_UNITSNEW_UNITSEXPANSION_UNITSCONTRACTION_UNITSCHURNEND_OF_PERIOD_UNITSDISCREPANCY
2020513Netflix0300030 
2020514Hotstar0000000 
2020613Prime301600190 
2020614Voot0000000 
2020713Youtube190000190 
2020714Sony0000000 
2020813Aha190100200 
2020814Mx Player0000000 
1 ACCEPTED SOLUTION
Greg_Deckler
Community Champion
Community Champion

@Gopal_PV I am thinking that you create measures for BoP, New, Expansion, etc. and then in a Matrix visual you turn on "Switch values to rows":

Greg_Deckler_0-1753990946596.png

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

2 REPLIES 2
Bmejia
Super User
Super User

You can create a sorting table, than link the table, than use the data from the sort table.

Example:
1. Create table and sort by sort number

Bmejia_0-1753992175552.png

2. Than link table

Bmejia_1-1753992204884.png

 

3. use the value from Sort table rather than main:

Bmejia_2-1753992278667.png

 

 



Greg_Deckler
Community Champion
Community Champion

@Gopal_PV I am thinking that you create measures for BoP, New, Expansion, etc. and then in a Matrix visual you turn on "Switch values to rows":

Greg_Deckler_0-1753990946596.png

 



Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
DAX For Humans

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors