Forum Discussion
Based on file name slicer selection , parse the data
Hi All,
I have a validation task to parse data and condtional format the data which doesnt match.
The data is about comparing the ECU software version present in the vehcile to the target version which is suppose to be.
Product software data - Which is a database table which has current ECU software version present in vehicle
Target Excel Files - Quartely will recieve a file and this will have the expected software version to be present in the vehcile and as of now have 2 files(2024 Q4,2025 Q1).
so based on the ECU key we can create the realtionship between the tables.
The requirment is need to compare the data between the tables based the selection of Target Excel Files from slicer.
Example - If user chooses 2024 Q4 or 2025 Q1 Target file from slicer then the parsing to happen between Vechile software data and 2024 Q4 or If user chooses 2025 Q1 Target file from slicer then the parsing to happen between Vechile software data and 2025 Q1
I need help on how with the help of slicer we can switch the Target data that to be compared with Product software data.
Below attached the source table info.
Product software data
| Product | timestamp | ECU_Name | HW_PartNumber | SW_PartNumber |
| 123 | 19-03-2025 11:31 | ATC01B | 000 446 25 30 002 | 000 448 32 30 001 22/34/00 |
| 123 | 19-03-2025 11:31 | EAM401B | 000 446 53 03 | 002 448 15 03 |
| 123 | 19-03-2025 11:31 | CLCS01B | 000 446 65 17 001 | 000 448 52 17 002 20/31/00 |
| 456 | 19-01-2023 14:15 | ATS01T | 000 446 25 44 004 | 000 444 06 44 |
| 456 | 19-01-2023 14:15 | CTP01T | 000 446 57 60 | 003 448 48 61 |
| 456 | 19-01-2023 14:15 | ACM301T | 000 446 74 55 | 017 448 68 54 |
| 456 | 19-01-2023 14:15 | TCO02T | 002 446 97 33 | 002 446 97 33 |
Target Excel Files - 2024 Q4
| ECU_Name | HW_PartNumber | SW_PartNumber |
| ATC01B | 000 446 25 30 001 | 000 448 32 30 001 22/35/00 |
| EAM401B | 000 446 53 03 | 002 448 15 03 |
| CLCS01B | 000 446 65 17 001 | 000 448 52 17 002 20/31/00 |
| ATS01T | 000 446 25 44 001 | 000 444 06 44 |
| CTP01T | 000 446 57 60 | 003 448 48 60 |
| ACM301T | 000 446 74 54 | 017 448 68 54 |
| TCO02T | 002 446 97 33 | 002 446 97 33 |
Target Excel Files - 2025 Q1
| ECU_Name | Hardware_Partnumber | Sofrware_Partnumber |
| ATC01B | 000 446 25 30 001 | 000 448 32 30 001 22/36/00 |
| EAM401B | 000 446 53 03 | 002 448 15 03 |
| CLCS01B | 000 446 65 17 001 | 000 448 52 17 002 20/31/00 |
| ATS01T | 000 446 25 44 001 | 000 444 06 44 |
| CTP01T | 000 446 57 60 | 003 448 48 60 |
| ACM301T | 000 446 74 55 | 017 448 68 54 |
| TCO02T | 002 446 97 33 | 002 446 97 33 |
4 Replies
Hi PraveenAK,
Please follow below steps and let me know if this helps?
- Import Product Software Data and Target Excel Files (2024 Q4, 2025 Q1). Append target files into one table with a "Quarter" column.
- Create Relationships: Product Software Data[ECU_Name] → Product Software Data[ECU_Name], Use a slicer on "Quarter" to switch target data dynamically.
- Mismatch Measure (for conditional formatting):
Mismatch_Flag =
IF(SELECTEDVALUE('Target Software Data'[SW_PartNumber])
<> SELECTEDVALUE('Product Software Data'[SW_PartNumber]), 1, 0)- Apply Conditional Formatting: Highlight mismatched SW versions in visuals.
Thanks,
Prashanth
Hi PraveenAK, As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?
Thanks,
Prashanth Are
MS Fabric community support
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query
Hi PraveenAK,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?
Thanks,
Prashanth Are
MS Fabric community support
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query
Hi PraveenAK,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided for your issue worked? or let us know if you need any further assistance here?
Thanks,
Prashanth Are
MS Fabric community support
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly and give Kudos if helped you resolve your query
