cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Nareshbaabu Frequent Visitor
Frequent Visitor

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

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 PowerBICapture.JPGI want only the 1st and last date values. This will be vary depends on user selection

2 REPLIES 2
Moderator v-qiuyu-msft
Moderator

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

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. 

 

q7.PNG

 

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

 

q6.PNG

 

Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Nareshbaabu Frequent Visitor
Frequent Visitor

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

@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!!!