Forum Discussion
Solved
Conditional formatting help
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 fo...
Hi, sarath_chandra
You can try the following methods.
Measure:
Current value = SUM('Table'[usage value])+0Previous value = CALCULATE([Current value],FILTER(ALL('Table'),[Weeknum]=SELECTEDVALUE('Table'[Weeknum])-1&&[PN]=SELECTEDVALUE('Table'[PN])))Diff = [Current value]-[Previous value]Color = IF([Diff]=0,"Yellow",IF([Diff]>0,"Green","Red"))Is this the result you expect? The last question is what kind of output you expect it to be, and can you show it in pictures.
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
every week i will get the data with date ,part numbers and usage values like this format BeaBF .
please help me out 🙏