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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Double header in matrix powerbi

Hi All,

 

I am new to PowerBI can someone please assist me on below? Thanks in advance.

 

I have created 6 Measures (i.e A1,A2,A3, B1,B2,B3) i need to show that in double header (A1,A2,A3 should show in A part and B1,B2,B3 should show in B part) like below (Table/Matrix)

Prathap22_0-1603725994518.png

Thanks,

Prathap

2 REPLIES 2
manikumar34
Solution Sage
Solution Sage

@Prathap22 ,

Create table as soemthing below

C1C2
AA1
AA2
AA3
BB1
BB2
BB3

And then use the SWITCH,TFEU functions to change your measurements for the values. As

SWITCH(TRUE(),SELECTEDVAUE(Table[C2])-A1,A1 measure.......

Place C1 and C2 under Columns in Matrix and Expand columns

Best regards

Manikumar





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


Proud to be a Super User!




Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.