I agree completely – this one is frustrating since it feels like we should be able to get closer than we’ve been able to. The calculated column issue (bullet point #1 above) means it will never be fully dynamic, but I got inspired by @sam.mckay’s updated video on TREATAS to give this one final shot before admitting defeat.
I created two measures (max and min) using TREATAS to transfer the filter from the normal distribution generated series to the SAP Minutes generated series. Here’s the max series measure (the min measure is identically structured):
SAP Minutes Treatas Max =
VAR MaxTreat =
ALLSELECTED( 'SAP Minutes Slider'[SAP Minutes] ),
'SAP Minutes Slider'[SAP Minutes]
VALUES( 'Normal Distribution Chart'[Generated Series] ),
'SAP Minutes Slider'[SAP Minutes])
From the screenshot below, both measures seem to be working exactly right - returning the proper values in the red cards.
I then generated a parameter column via:
SAP Minutes Treatas = GENERATESERIES( [SAP Minutes Treatas Min], [SAP Minutes Treatas Max], 1)
and then dropped this column into the orange slicer. However, not having the full data set available, I can’t do a complete refresh to see if the orange slicer endpoints will update properly when the full report recalculates on refresh. Thus, can you please take the file below, make sure the data path is correct, run a full refresh and let me know if the orange slicer endpoints change to the values in the red cards?
Thanks! Really curious to see if this works…