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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
sathiyen
Helper I
Helper I

Can we Use a column in Constant Line

Hi

I have Different Parameters data over a time period to display in Line Chart.

I have a two column which has Maximum and minimum threshold value of the parameters apart from that there is actual value.

Is there a way to use the Maximum and minimum column values in Constant line of the chart.

So if I select the parameters in slicer the constant line can vary base on the parameter name.

 

 

3 REPLIES 3
mussaenda
Super User
Super User

Hi @sathiyen ,

 

I am quite confused.

A constant line must be constant.

If you want a min and max line there is available in Analytics Tab.

 

2020_01_20_15_12_44_ASSEMBLY_MONITORING_test_Power_BI_Desktop.png

 

Hope this helps you well.

@mussaenda 

I agree Constant line is for constant vlaues. But it would be easier if we can map a column values in the place of constant value.

 

The Max and Min line will be retriving the values of Max / Min value of Column Value of the chart.

But I need to set the Max and Min Value from another column which is not used in the chart.

 

 

@sathiyen 

 

This is possible using the Min / Max Lines.

Provide sample data and your desired ouptut so other can also help you.

Be clear also wih the outputs that you need between Min and Max.

 

You can create some conditional columns the use it as you line

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.