Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Good morning, I'm trying to filter a line graph by the last date, which provides me with a date range filter. I would like the chart in this case to only appear values for 28/02/2022.
Solved! Go to Solution.
Hi, @Syndicate_Admin ;
Try to create a measure:
Flag =
var _max= CALCULATE(MAX('Table'[Date]),ALLSELECTED('Table'))
return IF(MAX('Table'[Date])=_max,1,0)
Then apply it into line chart.
The final output is shown below:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Syndicate_Admin ;
Try to create a measure:
Flag =
var _max= CALCULATE(MAX('Table'[Date]),ALLSELECTED('Table'))
return IF(MAX('Table'[Date])=_max,1,0)
Then apply it into line chart.
The final output is shown below:
Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Create measure like this. or create a measure and use that as visual level filter
measure =
var _max = maxx(allselected(date), Date[Date])
return
calculate(countrows(Table), filter(Date, Date[Date] =_max))
Good, I've tried the formula you put on me and it gives me back an integer, not the maximum date for the range of values.
On the other hand what you tell me about putting it as a visual filter, what would the configuration be like?
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
86 | |
84 | |
66 | |
62 | |
60 |
User | Count |
---|---|
197 | |
118 | |
108 | |
78 | |
69 |