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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
sfink22
Helper I
Helper I

Min/Max lines from another table?

I have time series data for equipment that I am trying to plot on a line chart with corresponding min/max lines. 

 

For each product run on the equipment, there is a single established min and max, all in a separate table. For example:

Product CodeMinMax
A26
B59
C15

 

My time series data is pulled based on what was run on the equiment that day. Any product can be run on any day, and there can be multiple products over the day. For example:

Product CodeDateTimeValue
A3/20/2010:30 AM4
A3/20/2011:00 AM4.5
B3/20/2012:00 PM7

 

I have made a relationship between the tables based on the product code. How do I plot the values for the product across dates and time, and add the corresponding min/max lines as constants on the same line graph? I have a slicer so that you can only view one product at a time, but the min/max lines are still aggregating across the entire data set, not just for the product selected.

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

Please find the file attached

 

View solution in original post

4 REPLIES 4
Icey
Community Support
Community Support

Hi @sfink22 ,

 

If you want to get the Maximum or Minimum value of each product, please try @vivran22 's method.

 

If you want to get the Maximum or Minimum value of all products, please replace the measures with these ones:

Max Value = MAXX(ALL('Max/Min Table'),'Max/Min Table'[Max])
Min Value = MINX(ALL('Max/Min Table'),'Max/Min Table'[Min])

 

 

Best Regards,

Icey

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

amitchandak
Super User
Super User

Please find the file attached

 

Exactly what I needed! Thank you!

vivran22
Community Champion
Community Champion

Hello @sfink22 

 

Is this what you are looking for?

 

Untitled.png

 

Solution file here

 

Cheers!
Vivek

If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Connect on LinkedIn

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors