High/Low/Current based on variable time range

[aflintdepm]

I've been asked to create a visual that plots current performance against a time range.  Some stakeholders want 52 weeks, some want 12 weeks, so I figure the easiest way would be to put a last XX weeks slicer on the report.

• First, can someone show me how to write the measure to identify the MIN and MAX allowing it to be filtered by a time slicer? If I use a single slicer for this, I would need to figure out how to exclude the current value from that slicer.
• Second, does anyone have any recomendations of the best way to present the data?  I'm considering a table with a high column, a low column, and a current column.  Alternate would be clustered column graph.

Any help or suggestion is appreicated.  Thank you

[Ashish_Mathur]

Hi,

I have solved a similar problem in the attached file.

Hope this helps.

[aflintdepm]

Thank you for sharing this.  I'm looking at it right now but I'm not able to follow what it is doing or how it would apply to my scenario.  Could you please give me a little background on it?  Thank you.

[Ashish_Mathur]

Please invest enough time to study it in detail.  It may not apply 100% to get you started but it sure is a springboard.

[aflintdepm]

I did study it- I would not have responded until I had done so and felt that my question was warranted.  I cannot decipher what the intent of your report is, so it is hard for me to understand how it relates to my request at all.  

[lbendlin]

For the first part you need to use a disconnected table that feeds your slicer. Then create a measure that senses the slicer selection and calculates the value accordingly.

[aflintdepm]

By disconnected, what are you referring to?