Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
sefreeman1
Frequent Visitor

Switching between Order date and Ship date

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!

 

7 REPLIES 7
lbendlin
Super User
Super User

What do you not like about USERELATIONSHIP ?

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.

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

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.  

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

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

 

sefreeman1_1-1710260395645.png

 

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors