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: 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. 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. 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. 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
