Forum Discussion
Transform Table to single view
Hello
I was wondering if you could help me. I have the following table where i have duplicate values.
And i want to display it like the following: ( ive only displayed 2 Riskgroup, but i want to show all the group in a single view)
| _au_contactlink_value | Risk Group | Response | Risk Level | Riskscore | Risk Group | Response | Risk Level | Riskscore |
| f310f664-262a-42db-8853-ac5c634c1e6a | Employment Type | Employed | Low | 0 | Account Usage | Making Payment to 3rd parties | High | 75 |
thanks
viral
Hello i was able to manage to do it.
In Power query i seperated the table to each groups and then added a custom number to represent the question and did a pivot to a single view.
2 Replies
Hi viralpatel21 ,
According to your description, you need to display groupings of data from different rows into one row.
It may not be possible to do the same as the example diagram, but you can achieve a similar effect with matrix visuals:
Best Regards,
Gallen Luo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello i was able to manage to do it.
In Power query i seperated the table to each groups and then added a custom number to represent the question and did a pivot to a single view.
