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

Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more

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
March PBI video - carousel

Power BI Monthly Update - March 2025

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

March2025 Carousel

Fabric Community Update - March 2025

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

Top Solution Authors
Top Kudoed Authors