Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
99 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
87 | |
64 |