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,
Does anyone know how to hide bars for future dates but keep the actual dates visible on the x-axis? I want my line chart to forecast for the future, but i dont want my bars to be populated for dates > TODAY().
i can't seem to get the logic right
PBIX below to show you what it currently looks like.
Thanks all.
https://drive.google.com/file/d/1-kUMJJK5lC4Wag8j3jJYcpwJzJzfeR3D/view?usp=sharing
Solved! Go to Solution.
@Anonymous , In that case control your measure
calculate([measure], filter('Date', 'Date'[Date] <today()))
Hope I it correctly.
@Anonymous , visual level filter, relative/advance date for last x year years including today. This will not allow future data.
See if this can help
Hi Amit,
The issue is that i still want the x-axis to show future dates as i need the line graph to show forecasting. I just want the bar charts to not populate for future dates as it doesn't make sense since no data should exist for it.
@Anonymous , In that case control your measure
calculate([measure], filter('Date', 'Date'[Date] <today()))
Hope I it correctly.
That worked like a charm. Thanks so much!
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 |
---|---|
114 | |
100 | |
78 | |
75 | |
50 |
User | Count |
---|---|
144 | |
109 | |
108 | |
87 | |
61 |