Dynamics F/SCM Customer Experience (CRM) Dynamics GP Dynamics Business Central (NAV) Dynamics SL Power Platform Fabric Copilot

[Mohamed Azarudeen]

Hi, please find below data set 

Location	values
A	1050
B	1000
C	1673
D	1016
E	1120
F	1220
G	1873
H	2089
I	3000
J	4903
K	2830
L	5140
M	1500
O	1765
P	2987
Q	1101

Based on this this data , i need show a visual like 

I need to show like above matrix . For example if data vale 1000- 2380= Show green color, 2381-3760 = yellow , and 3761-5140= Red color.

Is it possible show like this in Heat map , I am new to power BI , so please guide me how to do it in heat map or any other option.

Thanks and Regards,
Azar.

——————————
Mohamed Azarudeen
BI Developer
IV
chennai
9790777218
——————————

[Simon Lamb]

Hi ,

On your matrix visual you’ll have [Values] in the values bin, so click on the down chevron there and then on Conditional Formatting.  You have options for background colour, font colour, data bars and icons.  If you’re familiar with Excel’s conditional formatting then it should all make sense.  Conditional formatting is also available from the Formatting pane.

You should find everything you need there but let us know if you need more detailed guidance?.

Regards,

——————————
Simon Lamb
IT Consultant, Method Excel Ltd.
——————————
——————————————-

[Mohamed Azarudeen]

Hi ,

Thank you very Much for your reply,

Location	Values
A	44
B	22
C	66
D	45
E	55
F	60
G	20
H	35
I	56
J	45
K	56
L	25
M	10
N	25
O	45
P	65
Q	22

Based on this data have to find out max ,min , and med=(max -min)/3  ,

1000+1380 = 2380	min+med=Green color
2380+1380=3760	Green+med=Yellow color
3760+1380=5140	Yellow+med=Red color

Based on this condition can i create dynamic conditional formatting in Heat map below example

If the actual data change the heat map color will change as per calculation condition , is it possible to do it Power BI.
Thank you in Advance.

Thanks and Regards,
Azar.

——————————
Mohamed Azarudeen
BI Developer
IV
chennai
9790777218
——————————
——————————————-

[Vishesh Jain]

Hi ,

Please check out the following article on how to use conditional formatting.

https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting

If you scroll down in the article, you will see you can even use the DAX functions SWITCH() TRUE()  in a measure in order to get conditional formatting.

Hope this helps.

Thank you,?

——————————
Vishesh Jain
Owner
VR Construction
——————————
——————————————-

[Mohamed Azarudeen]

Hi ,
Thank you very Much for your reply .
I have done the task using Dax measure.?

Thanks and Regards,
Azar.

——————————
Mohamed Azarudeen
BI Developer
IV
chennai
9790777218
——————————
——————————————-