Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filled map with colour saturation: it colours also zero value countries

Hello all!

I've a simple filled map shaded by value (in this case a sum of investments in several sectors). I've also a slicer by sector.

When I slice by sector the map does change colour shade BUT countries with £0 value of investment in that sector still remain slighly coloured. I am attaching some pictures. Thank you!!

GiuliaOverviewUsing the slicer 

 

Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    7 years ago

    Hi Anonymous 

    It seems you are using old version of Power BI Desktop.

    You could create a measure like this

    measure=IF(SUM([value])=0,-1,SUM([value]))

    Then add this measure in the color saturation

    Configure the color setting Minimum to 0

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi - thanks and sorry! 

    My question is: how can I remove the colour from £0 value country? I just don't want them coloured.

    Thank you!

  • v-juanli-msft's avatar
    v-juanli-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous 

    It seems you are using old version of Power BI Desktop.

    You could create a measure like this

    measure=IF(SUM([value])=0,-1,SUM([value]))

    Then add this measure in the color saturation

    Configure the color setting Minimum to 0

     

    Best Regards
    Maggie

     

    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.