Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.
Dear support community,
I have two datasets with same number of columns: Current Day and Previous day.
Previous Day dataset
Number | Full Name | Can. Country of Residence | Area | Req. Expected Nationality | Req. Segment | Req. Estimated Start Date |
100 | Scarlett Reeves | France | EAF | France | Labor | 01/05/2020 |
101 | Haider Garcia | Russia | RCA | Russia | Operator | 01/05/2020 |
102 | Lois Zamora | UK | EAF | UK | Operator | 01/05/2020 |
103 | Joyce Massey | USA | NAM | USA | Mechanic | 01/05/2020 |
104 | Yunus Woodcock | Brasil | LAM | Brasil | Engineer | 01/05/2020 |
Current Day dataset
Number | Full Name | Can. Country of Residence | Area | Req. Expected Nationality | Req. Segment | Req. Estimated Start Date |
100 | Scarlett Reeves | France | RCA | Russia | Labor | 01/05/2020 |
101 | Haider Garcia | Russia | RCA | Russia | Operator | 01/05/2020 |
102 | Lois Zamora | UK | EAF | UK | Operator | 01/05/2020 |
103 | Joyce Massey | USA | NAM | USA | Mechanic | 01/05/2020 |
104 | Yunus Woodcock | Brasil | LAM | Brasil | Engineer | 02/05/2020 |
I would like to project in a vizualization the rows that have been modified and color code value(s) that have changed.
e.g
Number | Full Name | Can. Country of Residence | Area | Req. Expected Nationality | Req. Segment | Req. Estimated Start Date |
100 | Scarlett Reeves | France | RCA | Russia | Labor | 01/05/2020 |
104 | Yunus Woodcock | Brasil | LAM | Brasil | Engineer | 02/05/2020 |
or is there any more appropriate way to project the variances between the datasets?
I have tried to create New compare table with EXCEPT function, but not sure on the steps to apply to highlight the data differences.
thank you in advance
Solved! Go to Solution.
Hi @Anonymous ,
1.You can create row control measure like this and set its value = 1 in filters:
RowControl = IF(COUNTROWS(EXCEPT('Current Day','Prevoius Day'))>0,1,-1)
2.You can create the following measures like this:
Area_Font = IF(not SELECTEDVALUE('Current Day'[Area]) in DISTINCT('Prevoius Day'[Area]),"#FF0000",BLANK())
Nationality_Font = IF(not SELECTEDVALUE('Current Day'[Req.Expected Nationality]) in DISTINCT('Prevoius Day'[Req.Expected Nationality]),"#FF0000",BLANK())
Start Date_Font = IF(not SELECTEDVALUE('Current Day'[Req.Estimated Start Date]) in DISTINCT('Prevoius Day'[Req.Estimated Start Date]),"#FF0000",BLANK())
3.In Values, choose the column you compared one by one and find Conditional formatting -> Font color
4.In Font color, choose Format by Field value and under Based on filed, selected previous measure:
5.You will get the result that you hoped:
Here is the demo, please try it:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
1.You can create row control measure like this and set its value = 1 in filters:
RowControl = IF(COUNTROWS(EXCEPT('Current Day','Prevoius Day'))>0,1,-1)
2.You can create the following measures like this:
Area_Font = IF(not SELECTEDVALUE('Current Day'[Area]) in DISTINCT('Prevoius Day'[Area]),"#FF0000",BLANK())
Nationality_Font = IF(not SELECTEDVALUE('Current Day'[Req.Expected Nationality]) in DISTINCT('Prevoius Day'[Req.Expected Nationality]),"#FF0000",BLANK())
Start Date_Font = IF(not SELECTEDVALUE('Current Day'[Req.Estimated Start Date]) in DISTINCT('Prevoius Day'[Req.Estimated Start Date]),"#FF0000",BLANK())
3.In Values, choose the column you compared one by one and find Conditional formatting -> Font color
4.In Font color, choose Format by Field value and under Based on filed, selected previous measure:
5.You will get the result that you hoped:
Here is the demo, please try it:
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.