Filter pane works properly only with dates in rows not in columns

[Saap]

Hello all,

In my report I am trying to compare forecast with budget.
I created measure to check if a given month should be displayed in visual.

The measure works fine and marks the selected client and month with the number 2 if the conditions are met.

I put this measure in visual level filter and set it to show items when the value is 2.

The issue I have is that my solution seems to work only when my dates are put in table or in rows of matrix.
When I try to put dates in columns filtering doesn't work properly.

Here are examples using two clients.
Correct filtering in table:

Correct filtering with dates in rows and clients in columns in matrix (values are also switched to rows):

The filter breaks when I moved dates to columns and clients to rows:

Only months in green box should be displayed as the measure CHECK is equal to 2 in these months.

As you can see, the filter on visual is also set to CHECK = 2.

Anyone has an idea why it works like that and how to fix it?

[Anonymous]

Hi @Saap ,

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[amitchandak]

@Saap , check have have you used option -> Show item with no data on any row/column field. Option on right click

Also, remove the filter nad add it again and try