topic Re: Filter a Line Chart via DAX Measure to report ONLY for Max Date in DAX Commands and Tips

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

garynorcrossmmc — Mon, 03 Jun 2024 20:38:38 GMT

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?

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

lbendlin — Mon, 03 Jun 2024 22:47:15 GMT

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

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

Anonymous — Thu, 06 Jun 2024 01:47:42 GMT

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

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

Anonymous — Tue, 18 Jun 2024 07:09:31 GMT

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