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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
mapple1
New Member

Help pulling from multiple columns into one in matrix visual

Hi everyone,

 

I'm trying to pull data from a number of columns into one. The goal is approximately a matrix like this:

Goal.PNG

 

Unfortunately, I can't seem to get this right at all. My data looks like this:

Data Actual.PNG

 

This will all be using a month slicer to show current month and let the users look at past months. My issue seems to be I can't say all the actuals are related, along with the plan and variance. The columns just aren't working for me. 

1 REPLY 1
Anonymous
Not applicable

What do you mean by your "data looks like this"? Is this the source data? If so, then you need to do the below transformations:

  1. Unpivot all columns except the first column (month)
  2. Create a custom column (call it Z for the sake of this exercise) in which you extract the last 3 characters from the "Attribute" column that was created after the unpivotting the columns
  3. Replace the letters " Act", " Plan", and " Var" of the Attribute column with an empty string
  4. Now you can display the way you want using a Matrix visual: Attribute field in rows, Z field in columns, and Values field in Values

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

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

July PBI25 Carousel

Power BI Monthly Update - July 2025

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