Any idea to control the number of bar in bar chart by rank?

[xiumi_hou]

Dear all,

I want to create a bar chart for each question score. However, I do not want to show all the questions. 

I set two conditions in my filter panel:

1.The score is bigger than 1

2.I created a rank measure and set rank smaller and equal than 3

Which means choose the top 3 rank whose score is bigger than 1.

My question is, because my question score range 1-5, which means I may have 5 questions rank level 1(Ex. Score 5), 6 questions rank level 2(Ex.Score 4), 2 questions rank level 3(Eg. Score 3), which means , I will have total (5+6+2=13) bars on my bar chart. In such circumstance, Is there a way I can control the number of bar?  Thank you 

[JosefPrakljacic]

Hey @xiumi_hou ,

may I ask you to share a sample set of your data and of your rankx code?

I bet we just need to adjust your rankx a bit 🙂

Like in this case https://social.msdn.microsoft.com/Forums/en-US/f8fcaa4f-5bc5-464e-bd5f-b99da7ff6584/dax-for-rownumbe...

If this post was helpful may I ask you to mark it as solution and give it a 'thumbs up'? This will also help others

Have a nice day!

BR,
Josef
Graz - Austria