Forum Discussion

rohitMe's avatar
rohitMe
Advocate I
8 years ago
Solved

Custom Legend

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 sho...
Need Help
Tips and Tricks
  • v-juanli-msft's avatar
    v-juanli-msft
    8 years ago

    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's avatar
sukumararumugam
Frequent Visitor
8 years ago

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

 

Thanks!

rohitMe's avatar
rohitMe
Advocate I
8 years ago

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's avatar
    BhaveshPatel
    Super User
    8 years ago

    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.