Forum Discussion

Frequent Visitor

3 years ago

Solved

Using Slicer and Chart to Show Historical Data

Hi Everyone, I have a table of activities that has the total slack for each activity at different dates. I want to display a chart using a measure that plots the total slack by date for all the dat...

Need Help

amitchandak
3 years ago
vsorensen , If you are filtering one value and want a trend of more than that , then the slicer needs to be on an independent table

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = _max -5
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

https://youtu.be/UoDPMF0nh3Q

amitchandak

Super User

3 years ago

vsorensen , If you are filtering one value and want a trend of more than that , then the slicer needs to be on an independent table

//Date1 is independent Date table, Date is joined with Table
new measure =
var _max = maxx(allselected(Date1),Date1[Date])
var _min = _max -5
return
calculate( sum(Table[Value]), filter('Date', 'Date'[Date] >=_min && 'Date'[Date] <=_max))

Need of an Independent Date Table:https://www.youtube.com/watch?v=44fGGmg9fHI

https://youtu.be/UoDPMF0nh3Q