Forum Discussion
Show data over time based on dynamic date selection
Anonymous , You have create a measure like
Assume you are using date table joined to date of your table
Days =
var _max = maxx(allselected(Date), Date[Date])
return
datediff(Max(Table[Due Date]), _max, day)
If need add filter Table Due > _max
Days =
var _max = maxx(allselected(Date), Date[Date])
return
calculate(datediff(Max(Table[Due Date]), _max, day), filter(Table, Table[Due Date] >_max ))
Then you can use dynamic Segmentation for bucketing
Dynamic Segmentation Bucketing Binning
https://community.powerbi.com/t5/Quick-Measures-Gallery/Dynamic-Segmentation-Bucketing-Binning/m-p/1387187#M626
Dynamic Segmentation, Bucketing or Binning: https://youtu.be/CuczXPj0N-k
- Anonymous2 years agoNot applicable
Thanks,
this was not what I was looking for in the specific question. But this was very useful for other features in the same report! 🙂