Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 PowerBI
Solved! Go to Solution.
@Anonymous
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.
@Anonymous @v-chuncz-msft
Glad to hear that. By the way, to help close this thread, you may accept solution. Your contribution is highly appreciated.
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.
@Anonymous
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.
@Anonymous @v-chuncz-msft
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
@v-chuncz-msft thanks. I"ve used Max and Min expression to calculate my requirement. And got the solution.
Glad to hear that. By the way, to help close this thread, you may accept solution. Your contribution is highly appreciated.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
98 | |
97 | |
81 | |
77 | |
66 |
User | Count |
---|---|
126 | |
105 | |
103 | |
81 | |
72 |