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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jerryr125
Regular Visitor

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
Regular Visitor

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
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

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