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.
Hi Experts,
I Have measure showing top 10 city n 11th as other value. I want to show in pie chart but not able to show because measure can not be added in "Legend" field of Pie chart. Please help me to solve this issue.I have created column but not showing correct result.
Actual answer should be this.I have taken measure because measure shows correct value.. but same formula is not working for calculated column.
please help me to create correct column which shows above result.Thank you in Advance.
Solved! Go to Solution.
Hi,
I think this will work for you:
legend = var a = RANKX(Facebook, CALCULATE(SUM(Facebook[Impressions]), ALLEXCEPT(Facebook, Facebook[Region])),,DESC,Dense)
return
if(a >= 11 , "others", Facebook[Region])
Let me know if you need any help!
Hi,
I think this will work for you:
legend = var a = RANKX(Facebook, CALCULATE(SUM(Facebook[Impressions]), ALLEXCEPT(Facebook, Facebook[Region])),,DESC,Dense)
return
if(a >= 11 , "others", Facebook[Region])
Let me know if you need any help!
@Anonymous
Thank you so much... It solved my issue...
Hi,
For refrence i am attcahing link of Pbix file.
Want to display pie chart of top 10 city+ 11th as other values...
thank you in advance
https://drive.google.com/file/d/1nNSktMkDxrgLyyz0fZCnZwJxjOgyPrTw/view?usp=sharing
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 |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |