Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Is there a way for a measure to understand what's being shown in a visual with a scrollbar?
Example: I have a matrix with dates for rows, with a slicer on that date.
If someone selects a range of 6 months, for example, only 30 days will be shown in the visual, with a scrollbar allowing the user to see the rest of the date range.
Is there a way to get the min date available in the scroll window, so I can change the title of the visual, based on the min month shown in the visual?
For example, in the visual below, I would want the title to be "February",because the min (Start of Week) shown in the visual is 2/4/2024
Solved! Go to Solution.
@Anonymous , The min date in matrix you can get using measure and show that in title using fx
Min = minx(allselected(Date), Date[Date])
If you do want to scroll, consider pagination
https://www.fourmoo.com/2017/10/31/power-bi-how-to-do-pagination-in-power-bi-reports/
Hi @Anonymous
Unfortunately, it is not currently possible to write MEASURES based on scrollbars.
Because scrollbars does not have the function of filter;
However, it is possible to get the month based on the minimum date.
For your needs, I think the slicer is the optimal solution, maybe you can try this measure:
Measure = FORMAT(MIN('Table'[date]),"mmmm")
//Use the format function to format the smallest date to display as a month
Search for title in visualizations and select the fx to the right of the blank box.
Then in the What field should we base this on? box select measure.
The result is as follow:
Best Regards,
Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous , The min date in matrix you can get using measure and show that in title using fx
Min = minx(allselected(Date), Date[Date])
If you do want to scroll, consider pagination
https://www.fourmoo.com/2017/10/31/power-bi-how-to-do-pagination-in-power-bi-reports/
The pagination idea is great - I'd never thought of doing it that way