Forum Discussion
Community ChampionVisual to display data as a form?
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.
Most Valuable ProfessionalHi 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.
- 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.
- mwegener
Hi edhans ,
Maybe this is an alternative solution.
Generate an HTML Document and display it over the HTML Viewer.
If I answered your question, please mark my post as solution, this will also help others.
Please give Kudos for support.
- edhans
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.