Forum Discussion

eRic_LaU's avatar
eRic_LaU
Frequent Visitor
2 years ago

How to interactive measure value with visualizations map

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.

 

Need Help

2 Replies

  • ChiragGarg2512's avatar
    ChiragGarg2512
    Solution Sage
    2 years ago

    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's avatar
      eRic_LaU
      Frequent Visitor
      2 years ago

      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.