Filter a Line Chart via DAX Measure to report ONLY for Max Date

[garynorcrossmmc]

Hi all,

I have a requirement from our userbase that they'd like to be able to switch between measures reported in a line chart.  The trouble I'm running into is that some of these measures can only be reported as of the max date - metrics such as Open Roles, % of Employees on a Succession Plan, etc.  

Using the 'Open Roles' measure as an example, when a user selects the option on the left for 'Open Roles', I'd like the Line Chart to ONLY report the value for the maximum selected date and exclude the other Month/Year values from the axis:

I've tried MAX/MAXX/etc but am coming up short.  Any ideas?

[v-shex-msft]

Hi @garynorcrossmmc ,

Any update on this? Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

[v-shex-msft]

HI @garynorcrossmmc,

Perhaps you can create a table with these measure field names and use it as source slicer.
Then you can create a new measure formula with switch function to check the selected value and redirect to correspond measure results.

Regards,

Xiaoxin Sheng

[lbendlin]

That should work automatically in a proper data model. Return BLANK for all months you want to suppress.