Matrix

[Marico]

I have the following requirements from the user, but I am unsure how many are possible.

Model Structure:

The source and Target data come from two different database tables. The model also includes a date table.

Requirement:

I need to create a matrix like the above where:

1. The user should be flexible in changing the target month column for different months from the target table.

2. A user should have a slicer to choose the blue color code months. They are coming from the source table.

3. The default view should show the current end-of-the-year target column and the previous 5 months from the source table.

Here is the link to my working file - https://github.com/priyam2790/PBI/blob/main/matrix.pbix

Thank you!

[danextian]

Wait, is that on your screenshot what the user really wants? That will involve a measure/measures and a disconnected table with all the possible column combination names. For example for the one in pink current year end target (Dec-25), current year end target (Dec-26),etc. And what  period is current calendar year month? While you want is possible, it certainly is a lot of work.

[speedramps]

Try this

delete the slicers table

Fux the relationship

fix the measure

fully op % = MAX(Target[fully % op])

use the Date[month year] in the slicer

Download my PBIX solution from Onedrive here

Click here 

Please click [accept solution] and thumbs up button. Thank you