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,
I want to create a visualisation that is similar to the one given below:
I require the percentage of "Out City" entries for each zones and want the legend to show details as shown in the sample graph.
Ask for any clarification if needed
Thanks and Regards
Rohit
Solved! Go to Solution.
Hi @rohitMe
Create calculated columns
percentage = CALCULATE ( COUNT ( Sheet3[category] ), FILTER ( ALLEXCEPT ( Sheet3, Sheet3[zones] ), [category] = "O" ) ) / CALCULATE ( COUNT ( Sheet3[category] ), ALLEXCEPT ( Sheet3, Sheet3[zones] ) )
flag1 = IF([percentage]>0.4,"up","down")
Add column "flag1" in the Legend field, "percentage" in the Value field
Best Regards
Maggie
Hi @rohitMe
Create calculated columns
percentage = CALCULATE ( COUNT ( Sheet3[category] ), FILTER ( ALLEXCEPT ( Sheet3, Sheet3[zones] ), [category] = "O" ) ) / CALCULATE ( COUNT ( Sheet3[category] ), ALLEXCEPT ( Sheet3, Sheet3[zones] ) )
flag1 = IF([percentage]>0.4,"up","down")
Add column "flag1" in the Legend field, "percentage" in the Value field
Best Regards
Maggie
Can you share the sample data, will help you on this!
Thanks!
I wont be able to share with you the data but it is similar to the data table which I have posted in my original question.
Thanks and Regards
Rohit
Hi Rohit,
I would suggest you to create pie chart with legends on and then resize the chart to only show the legends.
There is no way you can create a custom legends in Power BI as far as I know.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |