Forum Discussion

derekli1700's avatar
derekli1700
Icon for Helper III rankHelper III
1 year ago
Solved

Need help making a Filter for a Matrix after Unpivoting?

Hi, I'm trying to make a filter for my matrix table but i'm running into a problem with duplicate values when unpivoting / unsure if there's a easier way without unpivoting   My (simplified) data T...
Need Help
Tutorial Requests
  • v-karpurapud's avatar
    v-karpurapud
    1 year ago

    Hi derekli1700 
    Thank you for reaching out to the Microsoft Community Forum.

    I have attached the PBIX file. Could you please check if it meets your expectations? If not, could you share the details? Please let me know.

     

    If I answered your question, kindly mark it as "Accepted Solution" so that it will help others find it easily.

    Thank you.

     
     

v-karpurapud's avatar
v-karpurapud
Icon for Community Support rankCommunity Support
1 year ago

Hi derekli1700 
Thank you for reaching out to the Microsoft Community Forum.

I have attached the PBIX file. Could you please check if it meets your expectations? If not, could you share the details? Please let me know.

 

If I answered your question, kindly mark it as "Accepted Solution" so that it will help others find it easily.

Thank you.

 
 

derekli1700's avatar
derekli1700
Icon for Helper III rankHelper III
1 year ago

Hi - this works thanks. Can you tell me how you did it for my future reference? Thanks