Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

COLOR BOX FOR LEGEND THAT SHOW %

Do anyone know how to show the percentage based on the data with specific color box like the photo?  
Show and Tell
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Anonymous ,

 

Accoridng to your statement, I suggest you to try conditonal formatting.

For reference: Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

Here I create a sample to have a test.

Measure:

Percentage = 
VAR _Value =
    CALCULATE ( SUM ( 'Table'[Value] ) )
VAR _Total =
    CALCULATE ( SUM ( 'Table'[Value] ), ALL ( 'Table' ) )
RETURN
    DIVIDE ( _Value, _Total )
Color = 
VAR _RANK = RANKX(ALL('Table'),[Percentage],,DESC,Dense)
RETURN
SWITCH(_RANK,1,"Green",2,"Yellow","Red")

Format your visual > Cell elements > Series [Percentage]>Background

Result is as below.


Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    May be i need to clarify something. The green color not meaning the largest percentage. The color must be in this order not matter the percenatge is, which mean it could be 1% for the green color and 98% for the red color.