Forum Discussion
Community ChampionVisual 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?
Thanks. Actually, I figured it out. Just needed to mull it over. The answer is:
- Create a reference to the original data
- Select the key column (Item Number in this case)
- Unpivot All Other columns
- 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.
5 Replies
- edhans
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.
