topic Switching between Order date and Ship date in Custom Visuals Development Discussion

Switching between Order date and Ship date

sefreeman1 — Wed, 06 Mar 2024 20:34:19 GMT

I've seen a few options on how I can select between two different date columns on the same row but they all go back to "userelationship" or an "if" statement that is needed for every single measure which is slowing down my report dramatically. How do I allow a user to select a date range but by the date column they want and have it apply across all measures/data points? Thanks!

Re: Switching between Order date and Ship date

lbendlin — Thu, 07 Mar 2024 22:37:37 GMT

What do you not like about USERELATIONSHIP ?

Re: Switching between Order date and Ship date

sefreeman1 — Fri, 08 Mar 2024 14:24:48 GMT

My understanding of USERELATIONSHIP is that it is on the measure level/calculation only. I'm looking to allow users to look at the same dash but select which date they want to view it by. So I want to see all my measures by order date or I want to see all my measures by ship date. Not necessarily both in the same view.

Re: Switching between Order date and Ship date

lbendlin — Fri, 08 Mar 2024 15:00:45 GMT

Yes, create separate measures and use them in a field parameter.

Re: Switching between Order date and Ship date

sefreeman1 — Fri, 08 Mar 2024 15:06:10 GMT

Then a user has to select every field parameter each time right? i.e. Margin - Ship date, Trailing 7 days Margin - Ship date, Rev, YTD Rev, etc. instead of just clicking "ship date" and all metrics changing.

Re: Switching between Order date and Ship date

lbendlin — Fri, 08 Mar 2024 15:17:47 GMT

That sounds like you want to combine this with calculation groups.

Re: Switching between Order date and Ship date

sefreeman1 — Tue, 12 Mar 2024 16:20:09 GMT

THought it might help to see what I'd like for the final output. Would calculation groups help with this? Is this in the model portion correct?

I'd like to filter by a data type, the date range and then pick a metric

Re: Switching between Order date and Ship date

lbendlin — Tue, 12 Mar 2024 16:46:15 GMT

Sounds reasonable. Yes, in the Model section, or in Tabular Editor. Let us know how you progress.