Forum Discussion

tasmiaa's avatar
tasmiaa
Advocate I
7 years ago
Solved

How to color a filled map dynamically

I have the following data:   Table with countries, date, and a value Country Value Year USA 3 2016 France 6 2016 Germany 2 2016 USA 1 2017 France 4 2017 Germany 5...
Need Help
  • tasmiaa's avatar
    tasmiaa
    7 years ago

    I found the solution:

    1. Keep measure Avg_Val_CurrentYear
    2. Create a new table-
      Table = SUMMARIZE(NATURALINNERJOIN('Table', 'Date'),'Table'[Country],'Date'[Date], "Value", [Avg_Val_CurrentYear] )
    3. Create a measure on the table for previous year
      Avg_Val_PreviousYear = CALCULATE (
      AVERAGE(Value),
      ALLEXCEPT ( 'Table', 'Table'[Country], 'Table'[Date]),
      DateADD('Table'[Date], -1, Year))
    4. Create a calculated column on the table
      Color = If(Value < Avg_Val_PreviousYear, "red", "green")
    5. Create a filled map with the country, value and color
       
       
       
tasmiaa's avatar
tasmiaa
Advocate I
7 years ago

Thanks, I was actually asking about a filled map and not a shape map, but I was able to figure out the issue. My solution is posted on the thread! :)