Forum Discussion

Zaku's avatar
Zaku
New Member
3 years ago

What visual or chart to be used to show Dense Ranking data

Dear Team,   For student performance, I have data with Ranking values. The lower Rank value denotes better or improvement in performance and the Higher rank value denotes lower or poor performance....
Need Help
Tips and Tricks
v-jianboli-msft's avatar
v-jianboli-msft
Community Support
3 years ago

Hi Zaku ,

 

If you want to display the performance of students in the chart, why don't you use the performance value to show the students' good or bad performance?
According to my knowledge, Power BI does not support showing a linear chart with a lower value showing improvement compared to a higher value currently. Please consider about use the performance value for the Y axis and use the rank value as tooltips. Tooltips are an elegant way of providing more contextual information and detail to data points on a visual. 

 

Besides, you can use the RANKX() function to achieve dense ranking in Power BI.

Note: Choose Dense in tiles parameter.

For more details, please refer to: RANKX function (DAX) - DAX | Microsoft Learn

 

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Zaku's avatar
Zaku
New Member
3 years ago

Hi Jianbo.

 

Thank you for the response. Yes, we can show % age and show Ranks in the tooltip. But in that case, the user needs to mouse hover to see the student's rank. I believe, there must be some options (way of visual)  to denote ranking. I will do some more research and see if can find any resolution.