Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get 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

Reply
ovetteabejuela
Impactful Individual
Impactful Individual

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.

1 ACCEPTED SOLUTION

Okay so the Matrix need a little help from HASONEVALUE.

 

I think I got this now.

View solution in original post

5 REPLIES 5
v-huizhn-msft
Microsoft Employee
Microsoft Employee

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
Not applicable

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!!!!

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.