Forum Discussion
Using two date slicers on a dataset to create one visual
I have a dataset like below
| Doc Date | Doc Type | Doc Num | Invoice date | Payment date | Customer | Debit $ | Credit $ |
| 01-Jun-22 | Invoice | D1 | 01-Jun-22 | C1 | 1000 | ||
| 10-Jun-22 | Invoice | D2 | 10-Jun-22 | C1 | 500 | ||
| 15-Jun-22 | Payment | D3 | 15-Jun-22 | C1 | 100 | ||
| 17-Jun-22 | Payment | D4 | 17-Jun-22 | C1 | 200 | ||
| 20-Jun-22 | Invoice | D5 | 20-Jun-22 | C1 | 2000 | ||
| 23-Jun-22 | Invoice | D6 | 23-Jun-22 | C1 | 1500 | ||
| 29-Jun-22 | Invoice | D7 | 29-Jun-22 | C1 | 3000 | ||
| 03-Jul | Payment | D8 | 03-Jul | C1 | 2000 | ||
| 08-Jul-22 | Payment | D9 | 08-Jul-22 | C1 | 1000 | ||
| 15-Jul-22 | Payment | D10 | 15-Jul-22 | C1 | 1500 |
Problem statement:
I need to make one visual with two slicers - Invoice date and payment date, which will show the invoices and payments for the corresponding periods. For example, if I choose invoice date as 01-Jun to 30-Jun and payment date as 01-Jun to 15-Jul, then the following result should be displayed - All invoices within the invoice date range and all payments in the payment date range.
Basically I would have two different date filters on the same table. How do I go about doing this.
Hi Anonymous ,
In addintion to Greg_Deckler's reply, I suggest you to create unrelated date tables and use measure to filter your measure.
Invoice date = CALENDARAUTO()Payment date = CALENDARAUTO()Measure:
Measure = VAR _Invoice_date = VALUES('Invoice date'[Date]) VAR _Payment_date = VALUES('Payment date'[Date]) RETURN IF(MAX('Table'[Invoice date]) IN _Invoice_date ||MAX('Table'[Payment date]) IN _Payment_date,1,0)Add this measure into your table visual and set it to show items when value =1.
Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Anonymous Use disconnected tables for your slicers. Then you can implement Complex Selector. The Complex Selector - Microsoft Power BI Community
Hi Anonymous ,
In addintion to Greg_Deckler's reply, I suggest you to create unrelated date tables and use measure to filter your measure.
Invoice date = CALENDARAUTO()Payment date = CALENDARAUTO()Measure:
Measure = VAR _Invoice_date = VALUES('Invoice date'[Date]) VAR _Payment_date = VALUES('Payment date'[Date]) RETURN IF(MAX('Table'[Invoice date]) IN _Invoice_date ||MAX('Table'[Payment date]) IN _Payment_date,1,0)Add this measure into your table visual and set it to show items when value =1.
Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
