Forum Discussion
Aligning dates
Hello,
I have a bunch of data by date for a handful of dates from a live SQL. I want to be able to track the different points on a graph with a slicer that chooses the point. A sum by time is a point I want to make.
I did this to get all the points together and a sum
The graph is exactly what I want, as is the matrix table, but because of how I did the middle table, the time becomes the slicer, not the point. How can I do this where the point becomes the selected in the slicer, not date and time?
2 Replies
Anonymous , Try like
XDDD1S1N01A = CALCULATE(
FIRSTNONBLANK(XDDD1S1N01A[DataValue],1),
FILTER(ALL(XDDD1S1N01A),XDDD1S1N01A[Timestamp] in values(Dates[Timestamp]) )
)Or use treatas
https://www.sqlbi.com/articles/propagate-filters-using-treatas-in-dax/
