conditional formatting help

[sarath_chandra]

Hi all,

actually ,above is my matrix visual in my power bi(PN is part number ,and values are usage of part number in every week of (2018,2019,2020,2021....)

i need some help in conditional formatting

1.dynamically it should show the latest week(9/2/2018) - Top 15 usage values.

2.There is lot of empty values are there in matrix values - need to bring zeros in empty places

3.dynamically,every week compare the previous week usage values (i) If the value is higher than previous week value - it should show some different font color or different back ground colour/symbol (ii) If the value is equal to previous week value - it should show some different font color or different back ground colour/symbol (iii)  If the value is less than previous week value - it should show some different font color or different back ground colour/symbol

4.If the usage of PN for continous three weeks - it should show all three values in different color/symbol

can you all please help me in this ? 

[lbendlin]

Please provide sample data that covers your issue or question completely.
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523