Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
71 |