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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

metrics in rows and columns

 I am very new to PowerBI. Is it possibe to create a matrix with the measures in both columns and rows. I have 3 metrics going across and row with 4 metrics going down the page (12 total). Data is coming from Teradata database.

 

 

 

 

 

Sample.JPG

 

3 REPLIES 3
Greg_Deckler
Super User
Super User

Yes, you should be able to do this, you would want to turn off the default "Stepped" layout for rows. You may also need to use the disconnected table trick. In general, to use a measure in that way, you need to use the Disconnected Table Trick as this article demonstrates: https://community.powerbi.com/t5/Community-Blog/Solving-Attendance-with-the-Disconnected-Table-Trick...


@ 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!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Anonymous
Not applicable

I don't see how this applies to what I am trying to accomplish as I really am such a newbie. But, I don't have missing data as I have only one fact table. There are columns for sales and targets. The report will show sales, a measure that shows variance to target and YOY sales.

 

I have Category in the Rows and Product in the column.

 

For each Category/Product I need to show 4 rows of various categories of sales with 3 metrics each as shown discussed above.

 

So for

                       Product 1                                               Product 2

Category 1

            sales 1 - variance 1 - YOY                                sales 1 - variance 1 - YOY

            sales 2 - variance 2 - YOY                                sales 2 - variance 2 - YOY

            sales 3 - variance 3 - YOY                                sales 3 - variance 3 - YOY

            sales 4 - variance 4 - YOY                                sales 4 - variance 4 - YOY

 

 

Category 1

            sales 1 - variance 1 - YOY                                sales 1 - variance 1 - YOY

            sales 2 - variance 2 - YOY                                sales 2 - variance 2 - YOY

            sales 3 - variance 3 - YOY                                sales 3 - variance 3 - YOY

            sales 4 - variance 4 - YOY                                sales 4 - variance 4 - YOY

 

All Category/Product combination have values for each of the 12 metrics.

I need 3 columns of metrics for each of the 4 sales values.

           

Anonymous
Not applicable

I actually figured out a different workaround.

 

My orginal fact table had

 

attribute 1, attribute 2, attribute 3, posted sales, gross sales, traffic, close

 

I created a lookup table

 

1=posted

2=gross

3=traffic

4=close

 

then created summary tables that I merged together and used type to group by

 

attribute 1, attribute 2, attribute 3, NEW Type, Actual

 

that's a bit of a simplified explanation

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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