Forum Discussion
viralpatel21
3 years agoHelper II
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 ...
- 3 years ago
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.
v-jialluo-msft
3 years agoCommunity Support
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.
viralpatel21
3 years agoHelper II
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.