Hi Everyone, I have spent all day trying to find a solution to this. Hope someone can help!
I have attached a very simple version of my model with sensitive client names etc removed. What I am trying to do is have a list of clients with a credit balance in a table along with their latest purchase date. I have done this and it’s working fine. Next I want a visualisation in this case a donut, but it could be anything showing the total value of credit balances in 3 different groups.
- Total credit balance value for clients that have made a purchase within last year
- Total credit balance value for clients that have made a purchase over a year ago
- Total credit balance value for clients that haven’t made a purchase at all
I have created all these measures and the donut is showing correctly. My issue is when I click on a segment of the donut, the corresponding table doesn’t filter to show only clients in that group. Not sure where I have gone wrong. Any help appreciated. Pbix file attached.
Test Model - Visual Filtering.pbix (432.0 KB)