How to add legend for color saturation distribution into power bi Filled Map chart

user_1706408 0
Viewed 15781

i have a power bi report "Filled Map" chart, where Location = "Cedent Country", and Color Saturation = "Percentage Brokerage Over Premium".

Percentage Brokerage Over Premium = Percentage Brokerage Over Premium = IFERROR(Round(SUM('Production ReportV20-V1 Power B'[Total Brokerage])/SUM('Production ReportV20-V1 Power B'[Cedent Premium]),2),0)

In Format --> Data Colors i configured color saturation as below:

  • Minimum: Red
  • Center: Orange
  • Maximum: Green

I need to show in the chart Legend to display color distribution (Minimum: red, Center: Orange, Maximum: Green), but i couldn't find the option any where.

I created another field Description = IF([Percentage Brokerage Over Premium]<0.1,"Low",IF([Percentage Brokerage Over Premium]>0.25,"High","Medium")) and tried to drag it into Legend field section however nothing happened.

appreciate your assistance.

Best regards,

enter image description here

enter image description here enter image description here

powerbi dashboard legend charts
2 Answers

Select chart and Visualizations -> select format tab

1) Select Data Colors enter image description here

2) select conditional formatting on Default color near right side icon enter image description here enter image description here

3) Select Minimum and Maximum color
enter image description here

user_46527060
Related