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 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.
Community ChampionThanks. 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.
Could you please elaborate on the steps to create this 'form view' for one record's data?
