Forum Discussion

RichA08's avatar
RichA08
Frequent Visitor
1 year ago
Solved

Filter Columns in Matrix with a date hierarchy

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. 

 

 

Need Help
  • v-lgarikapat's avatar
    v-lgarikapat
    1 year ago

    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.

6 Replies

  • Bmejia's avatar
    Bmejia
    Icon for Super User rankSuper User
    1 year ago

    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])
           )
  • v-lgarikapat's avatar
    v-lgarikapat
    Icon for Community Support rankCommunity Support
    1 year ago

    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's avatar
      v-lgarikapat
      Icon for Community Support rankCommunity Support
      1 year ago

      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's avatar
        v-lgarikapat
        Icon for Community Support rankCommunity Support
        1 year ago

        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.