Custom Legend

[rohitMe]

Hi,

I want to create a visualisation that is similar to the one given below:

output samplesample data

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 

[v-juanli-msft · Accepted 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

[sukumararumugam]

Can you share the sample data, will help you on this!

Thanks!

[rohitMe]

Hi @sukumararumugam

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

[BhaveshPatel]

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.