Forum Discussion
Need help with filters
Hello Power BI geniuses.
I have a fairly uncomplicated report that has 2 working visuals and one that I need to figure out. I am using this report for our Call Center reporting.
Visual 1 = Missed Calls by Date (Date, Number of Calls Missed, Avg Wait) A series of filters identify it as a missed call.
Visual 2 = Missed Call Details (Date and Time of call, Phone Number calling, Duration of call, and a bunch of others) Same filters as Visual 1.
Visual 3 = All calls from specific customer
I would like to click on a missed call record on visual 2 and then display on visual 3 all calls for the day with the same phone number. I think where the problem is coming in is that its a single data source but I feel I have tried everything I can think of.
Not sure how to make this work. please help.
hi xbommer07
If you want show the details for the callnumber that you click on second table viusal in third table visual on the one page, it could not achieve in power bi for now.
since when you click callnumber in second table visual, there are also other Dim([Result]/[Duration]) will be filtered too.
So two workaround:
1. use drillthrough to another page.
2. In second table visual, dim fields are only [Start Date] and [FromFullNumber], or other fileds must be aggregated.
Regards,
Lin
11 Replies
xbommer07 Take a look at the DAX function ALLSELECTED - https://www.sqlbi.com/articles/the-definitive-guide-to-allselected/
- amitchandak
Super User
If Date and phone numbers are used on Axis or as Rows and column in the matrix they should filter the third visual. Or you can move the third visual on a different page and use the drill through.
Can you share sample data and sample output.
It does filter down but to the same row. essentialy providing me with two visuals that are the exact same.
I added a reply to v-lili6-msft earlier this morning.
v-lili6-msftCommunity Support
hi xbommer07
You could create a measure for 3rd visual by the logic as below:
Measure=CALCULATE(COUNTA([Call]),FILTER(ALLSELECTED('Table'), [customer]=MAX([customer])))
If you still have the problem, please share your sample pbix file and your expected output.
Regards,
Lin
Good morning v-lili6-msft
I do not know how to attach PBIX file. The visual on the bottom right visual is only containing the measure you sent and it does present data however it is still filtering down to a single row. Not the complete list of all calls.
On the left is a summary of missed calls by date. On the top is a listing of those calls so when you click on a date on the left the top visual should show all calls for that date. I would like to then select a call that was missed from the top visual and have it show all calls for the same day from the same caller. In the data source 'Query 1' the caller is "CallerIDNumber".
- v-lili6-msft
hi xbommer07
What is your expected output?
For exanple:
Start Date is "3/22/2020" on the left, and when you selected Caller 2705549671 on the top, what is your expected output?
Regards,
Lin
