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

See when key Fabric features will launch and what’s already live, all in one place and always up to date. Explore the new Fabric roadmap

Reply
jerryr125
Helper III
Helper III

Createa a visualization to display data in a 'form' format

Hi 

I have the following table visualization (example):

 

IDDessert CategoryFood Name
1Ice CreamVanilla Ice Cream
2CookiesChololate Chip Cookies
3CakeCarrott Cake

 

When the end-user clicks on the ID (drill through) - it would go to a page displaying the following visualization:

 

  
ID 1
Dessert CategoryIce Cream
Food NameVanilla ICem Cream

 

 

Any thoughts ? Thanks - Jerry

 

1 ACCEPTED SOLUTION
parry2k
Super User
Super User

@jerryr125 maybe use matrix visual, add all the columns on the values section, and in the format pane, select "switch values to rows" and that will do it.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

3 REPLIES 3
parry2k
Super User
Super User

@jerryr125 maybe use matrix visual, add all the columns on the values section, and in the format pane, select "switch values to rows" and that will do it.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

jerryr125
Helper III
Helper III

Hi 

Very close...

I would like the multi-row card to display the fields in one column 

and the values in the other column...

 

Like this:

 

Any thoughts?

 

  
ID 1
Dessert CategoryIce Cream
Food Name

Vanilla Ice Cream

parry2k
Super User
Super User

@jerryr125 add multi-row card on drill thru page, and use ID column as drill thru column and that should do it.



Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤


Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Helpful resources

Announcements
May PBI 25 Carousel

Power BI Monthly Update - May 2025

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

May 2025 Monthly Update

Fabric Community Update - May 2025

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