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