Forum Discussion

utsavlexmark's avatar
utsavlexmark
Helper III
7 years ago

Legends in Power BI Filled Map

Hello,

Let me first explain the customizaation I am thinking of; actually I am not ssure wheter that is actually possible or not.

I am trying to potrait the countries in Power Filled Map. I am trying to select a range of Traffic amonut and on the basis of that color will be decided.

For example; countries with a traffic range of 2k to 5k will be shown as Green, 1k to 2k will be as blue and below 1k as red. I can do this by selecting Data Color with individual countries; but I want this to be happen autometically whenever the dataset will be uploaded. Also want to have those color in legends with the traffic range.

Hope I am clear with my concenpt.

Please let me know if this is actually possible or not.

Regards

Utsav

Tips and Tricks

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee
    7 years ago

    Hi Utsav,

     

    I would suggest you create a new column like below and then assign the color once. The color will be static when new data is loaded.

    Column =
IF (
    [Peak population] < 110000,
    "<1K",
    IF ( [Peak population] < 120000, "1K-2K", "2K-5K" )
)

    Legends-in-Power-BI-Filled-Map

     

     

    Best Regards,