powerbi

PowerBi Relationship with variable text

I have the below list of vehicles.

enter image description here

I then have the below list of vehicles with IVMS breaches. (speeding etc)

enter image description here

I need to use PowerBi to list the IVMS breaches but filter by the customers/contract.

I envision a slicer with the customers listed and as I change the slicer the IVMS breaches updates.

My list of breaches is a simple table of "Date" "Vehicle" "Breach" "Count".

Example: 07/01/2024 ABC001 SPEED 5

I need to be able to filter the trucks based on the customer/contract.

Any help would be appreciated!! :)

Solution

  • That type of composed values as:

    CUSTOMER001, CUSTOMER004, CUSTOMER005

    Would bring complexity to the model.

    As best practices, decompose this type of values as only 1 value in the way that for each vehicle exists only 1 customer, if the vehicle is repeating as a duple with the customer, that's fine. And if even this is duplicating for some reason, add other attribute like date, so this duple only happens once in that date if that's the case.

    And that needs to happen in the ETL phase, so you need to transform this type of values and decomplex in simple values.

    Then, you can build a simple relationship between the vehicles and the contracts in a easier manner. And remember, in PBI you can build as much tables as needed, despite those tables don't exist in the source data set.

    Good luck with your engagement with PBI.