Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello
I want to asked how to do conditional formatting on weekly data.
I want the background would be red if any week is less than previous week and the background would be green if its greater.
I already have date table in here.
The example data look like this :
Thank you
Solved! Go to Solution.
Hi @ChristoNindyo ,
You can use a custom measure to calculate the differences between weeks and assign a color code to each result, and then use this measure in the conditional formatting using the option 'Field Value' (please refer to image below).
An example of a custom measure for color coding:
Color Coding =
SWITCH(
TRUE(),
[This Week] < [Last Week], "#DC143C" // Red
[This Week] > [Last Week], "#85cc18" // Green
[This Week] = [Last Week], "#0c0c0c" // Black
)
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
Best regards,
Joao Ribeiro
Hi @ChristoNindyo ,
You can use a custom measure to calculate the differences between weeks and assign a color code to each result, and then use this measure in the conditional formatting using the option 'Field Value' (please refer to image below).
An example of a custom measure for color coding:
Color Coding =
SWITCH(
TRUE(),
[This Week] < [Last Week], "#DC143C" // Red
[This Week] > [Last Week], "#85cc18" // Green
[This Week] = [Last Week], "#0c0c0c" // Black
)
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
Best regards,
Joao Ribeiro
@ChristoNindyo it was just an example of measures with the current and last week values for the metric you are trying to compare. Please let me know if you need help with this part too.
Hope this answer solves your problem!
If you need any additional help please @ me in your reply.
If my reply provided you with a solution, please consider marking it as a solution ✔️ or giving it a kudoe 👍
Thanks!
Best regards,
Joao Ribeiro
User | Count |
---|---|
96 | |
86 | |
78 | |
72 | |
67 |
User | Count |
---|---|
110 | |
104 | |
84 | |
65 | |
63 |