Categorise in the Matrix

Question

Hi,This is my requirement. I want to show this table in Power BI without any changes in requirements.The main task is rank-wise categorized and displayed.I hope you understand my problem.&nbsp;Note: Take the Ranks depends on the time load on zones.&nbsp;

lbendlin · Answer

Please 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

sivasrao · Answer

Hi,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.&nbsp;Thank you in advance.&nbsp;

v-jingzhang · Answer

Hi&nbsp;sivasrao&nbsp;
&nbsp;
Is your original table data similar to below? Or in other format?&nbsp;

&nbsp;
Best Regards,Community Support Team _ Jing

sivasrao · Answer

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 · Answer

I cannot help further without sample data.

Forum Discussion

Categorise in the Matrix

7 Replies

Related content

Categorise average percentages

Total is wrong when categorised is vendor wise

Categorise Plus or Minus %

Matrix table

sorting matrix