how can i show different threshold in line chart

[Anonymous]

Hi , i want to show different threshold line in a line chart based on different category

also i want to show top 5 highest data in a line chart within 30 days. And threshold value should be straight line based on category type.

Any help will be appreciated.

[v-jingzhang]

Hi @Anonymous 

Do you want to show top 5 highest types in the line chart? If I understand it correctly, do you need to show total 20 lines (3*5=15 thresholds + top 5 type values) in a line chart at the same time? 

Usually there are two solutions for the threshold lines. One is to use the Analytics pane to add constant lines. 

The other is to create measures to get the threshold values from the respective table or set static threshold values for measures. For example,

Bike Low = CALCULATE(MAX('Table'[Low]),'Table'[Type]="bike")

Or

Bike high = 40

Add these measures to Y-axis or Secondary y-axis on the line chart. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.