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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
akhaliq7
Post Prodigy
Post Prodigy

In a matrix how do i give values a label as a row

I have a matrix whereby I place my numeric fields in the value tab I place my year into the column tab The final result requires the column headings in the row tab. How can I achieve this thanks.

 

i would like to get the below result

                               2021                       2022                                     Visualization tab

income                   100,000                  120,000                                 Rows

units                        1000                      1200                                     add data fields here 

                                                                                                          Columns

                                                                                                          years

                                                                                                          Values

                                                                                                          income

                                                                                                          units

 

but what i am getting is the following

 

                           2021                                    2022

                          income              units            income               units

                         100,000             1000             120,000               1200

 

 

1 ACCEPTED SOLUTION
akhaliq7
Post Prodigy
Post Prodigy

Found the answer after playing around in the format tab so go to visualizations -> format visual -> visual -> values -> options then turn on switch values in rows groups rather than columns

View solution in original post

1 REPLY 1
akhaliq7
Post Prodigy
Post Prodigy

Found the answer after playing around in the format tab so go to visualizations -> format visual -> visual -> values -> options then turn on switch values in rows groups rather than columns

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.