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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. 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
Employee
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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.