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.
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
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
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 |
---|---|
96 | |
95 | |
83 | |
70 | |
66 |
User | Count |
---|---|
118 | |
106 | |
93 | |
79 | |
72 |