Matrix Visual Not Filtering at the Column

[ovetteabejuela]

Hi community!

This is weird Matrix does behave properly when

      I have an Interval(table Field) by 30 minutes in my Row Section 

      A Date field on the column (as headers)

     and a count/value/data coming from another table field

                    - With the above I can filter by Month and all the dates that corresponds to that month on the Column(header) is filtered

But if I change the third parameter to a calculated measure the filter stopped working for the headers, it still shows every single date on the table but the Value changes but is incorrect or showing everything at 100% when I filter on month.

[v-huizhn-msft]

Hi @ovetteabejuela,

It’s difficult to reproduce your scenario based on your decription and find the reason. Is there any chance to post your sample data or .pbix file for analysis? So that we can post solution which is close to your requirement. 

Best Regards,
Angelia

[Anonymous]

https://community.powerbi.com/t5/Desktop/Matrix-columns-are-not-filtering-based-on-slicer-value/m-p/...

Could you please help me on this topic.

---

---

[ovetteabejuela]

One suspect is the FORMAT command on one of the values.

Say I have in the column Date

Some category on the Rows

and values in the Values section

if I issue a FORMAT command, and if I have a MONTH filter it does not filter on the dates - it shows all the days I have in that table.

[ovetteabejuela · Accepted solution]

Okay so the Matrix need a little help from HASONEVALUE.

I think I got this now.

[pcabrero]

Please @ovetteabejuela, could you share the complete solution???? I've found the same issue and I do not unserstand the tip you gave.

MANY THANKS ins advance!!!!