Reply
Frequent Visitor
Posts: 17
Registered: ‎08-01-2017
Accepted Solution

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

[ Edited ]

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.JPG


Accepted Solutions
Frequent Visitor
Posts: 17
Registered: ‎08-01-2017

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

@ManNVSM

 

I got a requirement from client like. It'll have date column, Acc No, Amount. 

User will select the two dates from Date slicer. And Matrix or Table visual will display values only for those dates. It'll have Max and Min date of selected between date.

I've created a expression to overcome this.

 

Got the solution by doing few work arounds.

 

Thanks for your replies guys.

@ManNVSM @v-chuncz-msft

View solution in original post

Community Support Team
Posts: 4,034
Registered: ‎07-09-2016

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

@Nareshbaabu,

 

Glad to hear that. By the way, to help close this thread, you may accept solution. Your contribution is highly appreciated.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post


All Replies
Community Support Team
Posts: 4,034
Registered: ‎07-09-2016

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

@Nareshbaabu,

 

A slicer is enough. You may check the following link.

https://community.powerbi.com/t5/Desktop/Relational-Date-Filter-By-Other-Date-How-To/td-p/298373

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Member
Posts: 71
Registered: ‎09-20-2017

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

Dear @Nareshbaabu,

 

Can you tell me more about your purpose? I can help your problem, if I know min,max for Axis Or filter a measure or just for your Filter Slicer?

 

Regards,

ManNVSM.

Highlighted
Frequent Visitor
Posts: 17
Registered: ‎08-01-2017

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

@v-chuncz-msft thanks. I"ve used Max and Min expression to calculate my requirement. And got the solution.

Frequent Visitor
Posts: 17
Registered: ‎08-01-2017

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

@ManNVSM

 

I got a requirement from client like. It'll have date column, Acc No, Amount. 

User will select the two dates from Date slicer. And Matrix or Table visual will display values only for those dates. It'll have Max and Min date of selected between date.

I've created a expression to overcome this.

 

Got the solution by doing few work arounds.

 

Thanks for your replies guys.

@ManNVSM @v-chuncz-msft

Community Support Team
Posts: 4,034
Registered: ‎07-09-2016

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

@Nareshbaabu,

 

Glad to hear that. By the way, to help close this thread, you may accept solution. Your contribution is highly appreciated.

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.