Based on file name slicer selection , parse the data

[PraveenAK]

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

[v-prasare]

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

[v-prasare]

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

[v-prasare]

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

[v-prasare]

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