Forum Discussion

Marico's avatar
Marico
Helper IV
1 year ago

Matrix

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!

Need Help

2 Replies

  • speedramps's avatar
    speedramps
    Super User
    1 year ago

    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

     

     

  • danextian's avatar
    danextian
    Super User
    1 year ago

    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.