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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Migscruz
Helper I
Helper I

Help with matrix in PBI

Hi, how can i make a matrix look like this in PBI? i have uploaded a file here so you can see how i want it to show in PBI.

 

The tab that says original is the data and the table that says "Should Look Like This in PBI" is how i want it to be in PBI. I know how to do this in excel but i want this to be in PBI. Hope u can help me. Data is here: https://transferxl.com/00jpbsPmZgWy7t

 

Migscruz_0-1605280120442.png

 

 

Thanks 🙂

1 ACCEPTED SOLUTION
CNENFRNL
Community Champion
Community Champion

Hi, @Migscruz , you might want to refer to the attached file for the method. Have fun!

Screenshot 2020-11-13 195242.png


Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

View solution in original post

2 REPLIES 2
CNENFRNL
Community Champion
Community Champion

Hi, @Migscruz , you might want to refer to the attached file for the method. Have fun!

Screenshot 2020-11-13 195242.png


Thanks to the great efforts by MS engineers to simplify syntax of DAX! Most beginners are SUCCESSFULLY MISLED to think that they could easily master DAX; but it turns out that the intricacy of the most frequently used RANKX() is still way beyond their comprehension!

DAX is simple, but NOT EASY!

mahoneypat
Employee
Employee

To do this, you will likely need to make a 2nd disconnected table of your column values (A..Z).  To get it to show in just one half of the matrix, you need some way to compare the row and column values, and use an IF along the line of = IF(MIN(Table1[Letter])<= MIN(Table2[Letter]), [Your Expression], "-")

Depending on what your expression is, you will likely need to use TREATAS() to pass the filter (column header value) from Table2 to Table1 for your calculation.

 

If your rows/columns are actual letters, that should work.  If not, you can have a Sort Order column on both and use that column in the MIN comparisons.

 

You can make the 2nd disconnected table with something like 

Table2 = DISTINCT(Table1[Letters])

 

Regards,

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


Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

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.