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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

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
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

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