How do we bring Max and Min date vales alone in Matrix visual in runtime user selection?

[Nareshbaabu]

Hi 

I want to create a Matrix visual which should restrict with min and max date values. Let me know how to we acheive this in PowerBII want only the 1st and last date values. This will be vary depends on user selection

[v-qiuyu-msft]

Hi @Nareshbaabu,

As you want to filter data based on the start date and end date of selected date range in slicer visual, you can change the slicer mode to List or DropDown to select these two desired dates to filter data. 

Also you can drag the same column field used by slicer to Visual/Page/Report level filter, then set condition with OR logic. 

Best Regards,
Qiuyun Yu

[Nareshbaabu]

@v-qiuyu-msft

Hi, If I make it to drop down, there is the possibility of users may by mistake select 3 or more values. 

I've tried a other method using DAX expressions. In that I was able to acheive my requirement.

Thanks for your reply!!!