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.
So i have two columns it look something like this:
5 12
3,4 3,4
12 9
And if i have other values in the same row i want to change background color to red.
Something like
5 12
3,4 3,4
12 9
Solved! Go to Solution.
Hi,
Please check the below picture and the attached pbix file.
1. create a measure like below.
Color format measure: =
IF( SUM(Data[Column1]) <> SUM(Data[Column2]), "Red")
2. each column, click down arrow, and then select Conditional formatting -> Background color
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
Please check the below picture and the attached pbix file.
1. create a measure like below.
Color format measure: =
IF( SUM(Data[Column1]) <> SUM(Data[Column2]), "Red")
2. each column, click down arrow, and then select Conditional formatting -> Background color
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
User | Count |
---|---|
84 | |
80 | |
72 | |
71 | |
55 |
User | Count |
---|---|
108 | |
106 | |
93 | |
85 | |
67 |