cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User II
Super User II

Visual to display data as a form?

I would like to display data like it was in a form. The MultiCard visual would work except I cannot figure out a way to control column widths and the number of columns. I would want it preferably to show with the field name and field value next to it. This would be for a drill through, so it would only show one item. Below is how it might look. This is just a transposed Power Query for demonstration purposes. I cannot use that though as there is no way to link the data in a relationship to my real table, and you can only transpose a certian amount of records anyway.

 

I can kind of hack a matrix to work by putting the Item Number in the row, then everything else in the Values, then show Values on Rows, but for text fields, instead of showing "UPC Number" for example, it shows "FirstofUPC Number" as the description, which just looks bad.

 

I've been unable to find a card/visual that will do what I want. By doing it as a true visual and not a hacked-up matrix, I may be able to use it as a tooltip report as well.

 

Any ideas?

 

2019-12-08 08_07_43-Untitled - Power Query Editor.png


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


MCSA: BI Reporting
1 ACCEPTED SOLUTION

Accepted Solutions
Super User II
Super User II

Re: Visual to display data as a form?

Thanks. Actually, I figured it out. Just needed to mull it over. The answer is:

  1. Create a reference to the original data
  2. Select the key column (Item Number in this case)
  3. Unpivot All Other columns
  4. Load the data and create the relationship.

 

It is actually a few more steps than that to cause it to sort properly vs alphabetically in DAX, but it works. The ToolTip report works as well, but is a bit less useful than I had originally thought due to the size restriction. I may still use it, but with the more common fields perhaps.

 

2019-12-08 15_56_33-Showing Info in a List or Form format - Power BI Desktop.png


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


MCSA: BI Reporting

View solution in original post

4 REPLIES 4
Super User III
Super User III

Re: Visual to display data as a form?

Hi @edhans 

 

Maybe you can use the PowerApp visual?

 

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Proud to be a Super User!

Super User II
Super User II

Re: Visual to display data as a form?

I'll have to look at that. I also had some ideas this afternoon about unpivoting and/or pivoting data in PQ then bringing that in. I'll have to look at the Power Apps license requirements too. Data is in an on-prem SQL server and that requires a P1 or higher license. Don't want to have to buy that for PBI users.


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


MCSA: BI Reporting
Super User III
Super User III

Re: Visual to display data as a form?

Hi @edhans ,

 

Maybe this is an alternative solution.

Generate an HTML Document and display it over the HTML Viewer.

https://community.powerbi.com/t5/Desktop/HTML-viewer-to-show-filter-selections/m-p/639676/highlight/...

 

If I answered your question, please mark my post as solution, this will also help others.

Please give Kudos for support.

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

Proud to be a Super User!

Super User II
Super User II

Re: Visual to display data as a form?

Thanks. Actually, I figured it out. Just needed to mull it over. The answer is:

  1. Create a reference to the original data
  2. Select the key column (Item Number in this case)
  3. Unpivot All Other columns
  4. Load the data and create the relationship.

 

It is actually a few more steps than that to cause it to sort properly vs alphabetically in DAX, but it works. The ToolTip report works as well, but is a bit less useful than I had originally thought due to the size restriction. I may still use it, but with the more common fields perhaps.

 

2019-12-08 15_56_33-Showing Info in a List or Form format - Power BI Desktop.png


Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


MCSA: BI Reporting

View solution in original post

Helpful resources

Announcements
Exclusive LIVE Community Event #3 – Ask Arun Anything

Exclusive LIVE Community Event #3 – Ask Arun Anything

Join us in the third Triple A event!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors