Made a custom 3 column to make the matrix dynamic

I was facing an issue with the behavior of columns in a matrix visualization, specifically with how measures are displayed across columns in the Values section. Here’s how I approached the solution:

1. Matrix Behavior:

   • When dragging fields into the Values section of a matrix, the measures are automatically segregated across all columns in that section.
   • This was not the desired behavior for my report.

2. Creating a New Table:

   • To address this, I created a new table using DAX with the UNION function.
   • The UNION function allowed me to construct a table that aligned with my requirements.

3. Using USERELATIONSHIP and Non-Active Relationships:

   • I created a measure utilizing the USERELATIONSHIP function and established a non-active relationship between the new table and the existing data.
   • This setup was essential to control how the data interacts across tables.

4. Slicer and Matrix Configuration:

   • I placed the historical year from the main table into a slicer.
   • In the matrix, I used the year field from the newly created table.
   • As a result, when a year is selected in the slicer, the matrix displays that selected year along with the other 2-4 columns as required, without automatically segregating the measure. 
     PowerBl matrix