How can I choose additional months to display in a matrix and show specific metrics for the aditiona

[r_viana]

Hi everyone,

I am struggling to achieve a solution on my report that is a matrix with months in columns, products by row and some metrics that the user can select which it gets to see. 

For now, it's like this:

The problem is that my user wants to select different months to see in the same matrix, but those months would only show values for the selected measures in another slicer - they want to see every metric for the first date slicer, but only the select measures for the referency months they select. 
So the layout would be something like this:

In the example above, the matrix should show the months selected in both slicers (may (default), april and march (referency)).

In may it should show every measure (doens't consider "ref metrics" slicer), for the other months it shoud show only the selected measure.

The modelling I've defined for testing is this:

(calendar2 is a calendar clone)

Heres a sample file with the data in those prints:
pbix file 

I appreciate any direction and help you guys could give me. 

So far I've tried to use "UNION" for both months but couldn't get it to work in the matrix (only the default calendar month was showed)

[Anonymous · Accepted solution]

Hi @r_viana,

AFAIK, current power bi use 'AND' logic to link different filters.

So if you want to display all items on the slicer, you need to the turn off the interaction between the first and second slicers or create an unconnected table as source of slicer and write measure formula to use on 'visual level filter' to filter records.

Regards,

Xiaoxin Sheng