Forum Discussion
using drill through with multiple criteria selection
hi there,
this is my first post, so forgive me. here goes.
I have a nice tool set up but my user would like to select multiple critera before using the drill through tool. I see that there is a way to write a DAX query, but most of the query suggestions I see are for time/date options.
This report is for fundraising prospecting, so I need to select criteria like interest unit, with a prospect rating, or unit and the last gift amount. I've got some sample/dummy data, but I don't have a great way to share it right now.
here's just the header and first row.
| CONSTITUENT LOOKUPID | FULLNAME | PROSPECTPLANNAME | PROSPECT PLAN DIMID | PROSPECT PLAN IS ACTIVE | Rating | primary manager | prospect manager | PROSPECTPLANSTATUS | PROSPECTPLANTYPE | PROSPECTPLANNAME | lifetime GIVING | Entity1Name | LAST GIFT FY | LAST GIFT DATE | DESIGNATIONPUBLICNAME | LAST GIFT AMT |
| 8000 | Dennis, Mrs. Tammi | B_NURS_Qualification | 1008 | 1 | K - $100,000 - $249,999 | Referrals & Transfers | No Constituent | Stewardship | Qualification | C_NURS_Qualification | $565.00 | Denniss, Mrs. Tammi | 2020 | 2/21/2020 | Nursing Scholarship Fund | $25.00 |
thanks,
Theresa Markham
1 Reply
- v-yalanwu-msft
Community Support
Hi, Anonymous ;
Base on my understand, you could use conditionally Drill-through action in Power BI. Here are some materials I hope will help you.
https://www.youtube.com/watch?v=AYpaXccbBvA
https://visualbi.com/blogs/microsoft/powerbi/conditionally-drill-action-power-bi/
I am not sure if I have understood your meaning correctly, please correct me if not.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.