Forum Discussion

PraveenAK's avatar
PraveenAK
Frequent Visitor
1 year ago

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...
Need Help
Show and Tell
Tips and Tricks
v-prasare's avatar
v-prasare
Icon for Community Support rankCommunity Support
1 year ago

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