Filter Columns in Matrix with a date hierarchy

[RichA08]

HI!

I only want to see the items with a negative value in each month. The months are all part of 1 column due to it being a date hierarchy. When I filter the value, it is not applying to all the columns. 

[v-lgarikapat · Accepted solution]

Hi @RichA08 ,

Thanks for reaching out to the Microsoft fabric community forum.

@Ashish_Mathur , @Bmejia 

Thanks for your prompt response

@RichA08 , 

Could you please provide sample data that fully represents the issue or question you're referring to? Kindly ensure the data is in a usable format ( Excel or CSV) rather than a screenshot, and does not contain any sensitive or unrelated information. 

Looking forward to your response.

Best regards,
Lakshmi.

[v-lgarikapat]

Hi  @RichA08 ,

We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

Best Regards,
Lakshmi.

[v-lgarikapat]

Hi @RichA08 

We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

Best Regards,
Lakshmi.

[v-lgarikapat]

Hi @RichA08 ,

We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

Best Regards,
Lakshmi.

[Ashish_Mathur]

Hi,

Share the download link of the PBI file.

[Bmejia]

you need to use a If statement or switch statement so that you can declare anything below 0 will show 0 in your measure, measure column. or if you just dropping a value from a column then you need to do it using  a measure or measure column.
Example: you can selectvalue, sum, max not sure what your calculation is doing but should looks something like this.

Measure=
IF(
       SELECTEDVALUE(PurchaseOrdersAging[Aging])<=0 
       ,0
      ,SELECTEDVALUE(PurchaseOrdersAging[Aging])
       )