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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
atowriss74
Regular Visitor

Adding Calculated Colum to Matrix Visual

Hi,

 

I have the below Matrix, which has Channel Names as Rows.  I want to add a column at the end that Calculates % Variance of the CYD and PYTD ONLY columns, by Channel.  Is this possible?  I have Tabular Editor installed, if that could be used as an option.  

 

I have a measure created, and could put that in another Matrix, but they won't be linked, so sorting would be an issue.

 

Is what I want to do even possible?Matrix Pic.PNG

1 ACCEPTED SOLUTION

@Greg_Deckler , that is going to be my temporary solution for now!

View solution in original post

4 REPLIES 4
Greg_Deckler
Super User
Super User

@atowriss74 It is possible, but not pretty. The New Hotness (Custom Matrix Hierarchy) - Microsoft Power BI Community



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!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler ....wow.  That seems a bit above my current knowledge, but I will study it.  Thanks so much

@atowriss1 Well, you can always go the other route of just adding the column to Values, turning off word wrap for headers and values and then shrinking up all the extraneous columns it creates in your visual...



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!:
Power BI Cookbook Third Edition (Color)

DAX is easy, CALCULATE makes DAX hard...

@Greg_Deckler , that is going to be my temporary solution for now!

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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