Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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.
Solved! Go to Solution.
Okay so the Matrix need a little help from HASONEVALUE.
I think I got this now.
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
Could you please help me on this topic.
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.
Okay so the Matrix need a little help from HASONEVALUE.
I think I got this now.
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!!!!
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
87 | |
84 | |
65 | |
49 |
User | Count |
---|---|
140 | |
114 | |
110 | |
59 | |
59 |