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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
baiju
Frequent Visitor

Row to Columns values with formatting

I have an excel data source which has Account related information.  columns include Account Name, Account Market, etc.. The requirement is to show the Each Account account row values in a column as showing in the reference image below. 

 screenshot-1.png

 

 

I tried to use Multi-Card visual And got below structure

 

Multi row card.png

 

Here, columns cames ( category lables in the card visual) coming to bottom and the hyperlinks are not working. Do we have any other visual which will give expected output as in reference image or any formatting we can do using dax?  

 

Thanks in advance.

1 ACCEPTED SOLUTION
Anonymous
Not applicable

You can using the Matrix visual.  On the Values section of formatting, click "Show on Rows".

 

That should give you what you're looking for: a 2 column table.  Left column is measure name, right column is value.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

You can using the Matrix visual.  On the Values section of formatting, click "Show on Rows".

 

That should give you what you're looking for: a 2 column table.  Left column is measure name, right column is value.

Thanks. Will try the same.

baiju
Frequent Visitor

I have an excel data source which has Account related information.  columns include Account Name, Account Market, etc.. The requirement is to show the Each Account account row values in a column as showing in the reference image below. 

 screenshot-1.png

 

 

I tried to use Multi-Card visual And got below structure

 

Multi row card.png

 

Here, columns names ( category labels in the card visual) coming to bottom and the hyperlinks are not working. Do we have any other visual which will give expected output as in the reference image or any formatting we can do using dax?  

 

Thanks in advance.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

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.

Top Solution Authors
Top Kudoed Authors