Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello All,
Below is my data and I need to color (background) for each 3 rows.
Date 5/5/2021 and 5/7/2021 rows has to fill with backgorund blue colors. Rest background will be white.
Please suggest.
Date | Sample | P1 | P2 | P3 |
5/4/2021 | 1 | 10.41 | 10.31 | 10.14 |
5/4/2021 | 2 | 10.52 | 10.59 | 10.94 |
5/4/2021 | 3 | 10.69 | 10.41 | 10.37 |
5/5/2021 | 1 | 10.84 | 10.59 | 10.47 |
5/5/2021 | 2 | 10.2 | 10.01 | 9.88 |
5/5/2021 | 3 | 10.49 | 10.36 | 10.26 |
5/6/2021 | 1 | 10.27 | 10.61 | 10.35 |
5/6/2021 | 2 | 10.18 | 9.85 | 9.9 |
5/6/2021 | 3 | 10.78 | 10.94 | 10.28 |
5/7/2021 | 1 | 10.84 | 10.59 | 10.47 |
5/7/2021 | 2 | 10.2 | 10.01 | 9.88 |
5/7/2021 | 3 | 10.49 | 10.36 | 10.26 |
Solved! Go to Solution.
@Anonymous , Create a measure like below and use that in conditional formatting using field value option
meausre =
if(max(Table[Date]) >= Date(2021,5,5) && max(Table[Date]) <= Date(2021,5,7) , "Yellow", "White")
You have to use this measure for conditional formatting using the field value option, use for each column
How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4
Thank you @amitchandak . You are awesome.
Some how I have given dummy data. Orignially I have two months data and need to color for each alternate date with yellow and while. So I have used below formula and it worked. Thanks again for your time.
@Anonymous , Create a measure like below and use that in conditional formatting using field value option
meausre =
if(max(Table[Date]) >= Date(2021,5,5) && max(Table[Date]) <= Date(2021,5,7) , "Yellow", "White")
You have to use this measure for conditional formatting using the field value option, use for each column
How to do conditional formatting by measure and apply it on pie?: https://youtu.be/RqBb5eBf_I4
Thank you @amitchandak . You are awesome.
Some how I have given dummy data. Orignially I have two months data and need to color for each alternate date with yellow and while. So I have used below formula and it worked. Thanks again for your time.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
90 | |
81 | |
65 | |
65 | |
61 |
User | Count |
---|---|
170 | |
114 | |
102 | |
73 | |
69 |