Forum Discussion
Matrix Visual Not Filtering at the Column
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.
Okay so the Matrix need a little help from HASONEVALUE.
I think I got this now.
5 Replies
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,
AngeliaOne 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.
Okay so the Matrix need a little help from HASONEVALUE.
I think I got this now.
Could you please help me on this topic.
