Forum Discussion
Helper IIICategorise in the Matrix
Super UserPlease provide sanitized sample data that fully covers your issue.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Please show the expected outcome based on the sample data you provided.
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Helper IIIHi,
I can't able to send sample data.
Just i want to create a table that same as the one in question.
Ignore that Note point which is highlighted in red color.
Thank you in advance.
v-jingzhangCommunity Support
Hi sivasrao
Is your original table data similar to below? Or in other format?
Best Regards,
Community Support Team _ Jing- sivasrao
Thank you for the quick reply.
Yes, partially it is similar. but 4th column is not present in my data.
Based on the ranks, it has to categorize automatically the ranks from 1-3 one group, and 4-6 one more group, and display the details accordingly.
I think we can use some measures for grouping these ranks and displays. I need that logic.
Thank you.
- lbendlin
I cannot help further without sample data.
- sivasrao
Ok.
Please, explain what is the logic behind the grouping of the first 3 ranks in one group. next 3 ranks in one more group etc.