How to interactive measure value with visualizations map

[eRic_LaU]

Greetings!

I'm new on PBI, and now creating a ratio table. 

I have a table with road travel speed, and would like to compare a section of road from different day (day 1 "Measure", day 2 "Comparison", and a measure "ratio" was created). After the ratio has been calculated I would like to plot into the visualizations map with colour displayed, for ratio > 0 then "Green" for ratio <0 then "Red"

The "Ratio" cannot directly use in the map, but when i put the "ratio" into the column, the value come out not exactly the compare of 2 days, it only calculate overall average of 1 day. The days was selected by using the slicer filter how can i interactive the result with the filter and the table? Thanks.

But I can't put the ratio to the Route Map - Colour Legend.

I want the colour display base on the ratio, if the ratio >=0 then it display "Green", otherwise "Red"

Looking for anyone can help, thanks a lot.

[ChiragGarg2512]

@eRic_LaU , create a measure using switch statement where if the condition fits its one color and doesn't another color.

Ex.

Color Scatter =

var _dis = CALCULATE([Discount %], ALLSELECTED())

var _mrg = CALCULATE([Margin %] , ALLSELECTED())

Return

Switch(True() ,

[Margin %]  > _mrg && [Discount %] <= _dis, "Green",

[Margin %]  > _mrg && [Discount %] > _dis, "Blue",

[Margin %]  <= _mrg && [Discount %] <= _dis, "Yellow",

[Margin %]  <= _mrg && [Discount %] > _dis, "Red")

Creating a measure in a format like this might help.

[eRic_LaU]

Thanks for your reply but the solution may not help.

I have a table with road travel speed, and would like to compare a section of road from different day (a measure "ratio" was created). After the ratio has been calculated I would like to plot into the visualizations map with colour displayed, for ratio > 0 then "Green" for ratio <0 then "Red"

But when i put the measure "ratio" into the column, the value come out not exactly the compare of 2 days, it only calculate overall average of 1 day. The days was selected by using the slicer filter how can i interactive the result with the filter and the table? Thanks.