add a filter for user to choose which method to calculate and show corresponding matrix in PBI

[pang22]

Hello,

I have a table below in Power BI. 

It shows the overdue date information and indicates how long it overdue (1-30days or >30days) using the Due_Date and Revised Due date.

Power BI:

Customer	Amount	Due_Date	Revised Due date	Today - Due_Date	Today - Revised Due date	Overdue (Today - Due_Date)	Overdue (Today - Revised Due_Date)
A	10	10/20/2023	10/22/2023	5	3	1-30days	1-30days
A	20	9/2/2023	10/2/2023	53	23	>30days	1-30days
A	20	8/8/2023	10/8/2023	78	17	>30days	1-30days

In Power BI Report view, how to add a filter for user to choose which method to calculate and show corresponding matrix?

For example, if user chooses Overdue (Today - Due_Date) to calculate, it will show the left table.

If user chooses Overdue (Today - Revised Due_Date) to calculate, it will show the right table.

[Magkru]

I think you need two separate filters to achieve this: one for Overdue (Today - Due_Date) and second for Overdue (Today - Revised Due_Date)