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 All,
I have a chart which has data for all dates from last 30 days. I want to show data of only latest date as the default visible data on my chart and then let user decide what data from previous days is required by giving an option of date filter.
Dataset is refereshed each day and value of latest day is added to it.
Whenever I open my report I get values of all 30 days on chart instead I want value of only latest day.
Hope I am able to explain my scenario.
Please let to me know how to achieve this task.
Thanks,
Shivam
Solved! Go to Solution.
Hi Greg,
Thanks for the link. Apologies that the information was enough.
But eventually I figured out the solution.
Solution:
I am using relative option in the slicer which gives me the latest date and have bookmarked that page. So now whenever I open the report, I get to see the bookmarked page having data with latest date.
-Shivam
So, you probably want a measure along the lines of:
Measure = IF(ISFILTERED([Date_Column]),[Date_Column],MAX([Date_Column])
Tough to really say without sample data, etc. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
Hi Greg,
Thanks for the link. Apologies that the information was enough.
But eventually I figured out the solution.
Solution:
I am using relative option in the slicer which gives me the latest date and have bookmarked that page. So now whenever I open the report, I get to see the bookmarked page having data with latest date.
-Shivam
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 |
---|---|
106 | |
94 | |
76 | |
62 | |
50 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |