Display Highest and Lowest Value in Field Map visual.

[Puja_Kumari25]

Hi All,

Can we display the highest and lowest values in the field map?

Thank you.

[Anonymous · Accepted solution]

Hi @Puja_Kumari25 

You can custom the fill color by using conditional formatting to display the highest value and the lowest value.

e.g I have the following state table, i need to display the highest count to green , the lowest count to red, others to yellow.

Create a measure

MEASURE =
VAR A =
    SUMMARIZE ( ALLSELECTED ( 'Table' ), [State], "Count", COUNTROWS ( 'Table' ) )
VAR b =
    SUMMARIZE ( FILTER ( A, [Count] = MAXX ( A, [Count] ) ), [State] )
VAR c =
    SUMMARIZE ( FILTER ( A, [Count] = MINX ( a, [Count] ) ), [State] )
RETURN
    SWITCH (
        TRUE (),
        SELECTEDVALUE ( 'Table'[State] ) IN B, "green",
        SELECTEDVALUE ( 'Table'[State] ) IN C, "red",
        "yellow"
    )

Then put the measure to the conditional formatting of the fill color

Output

And you can refer to the following link.

https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-filled-maps-choropleths?ta...

Best Regards!

Yolo Zhu

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