How to change target line

[Anonymous]

Hi Power BI Community,

Good day. I would like to seek help on how to change the target line depending on the country's target. Is there a way to change the target line based on that? Currently, I am using constant line but I need changing target. Hope you can help me. 

[amitchandak · Accepted solution]

@Anonymous , If you are using an X-axis/Y-axis constant line in the analytics pane, there is an option of fx(under the line in the new pane) , You can have a measure which can change base on selected country and use that there.

If country is part of the visual you can have a measure in clustered bar and line visual  as line

measure = calculate(sum(Table[Target]), filter(Allselected(Table), Table[Country] = max(Table[Country] ) ))

[Anonymous]

Thank you, @amitchandak and @VahidDM ! It's working now. 🙂

[Anonymous]

Hello. I am trying the formula, is this correct? 

Target = Calculate(Sum(AppTarget[Target]), Filter(Allselected('SC_On Time Approval'), 'SC_On Time Approval'[Country] = Max('AppTarget'[Country] ) ))

[VahidDM · Accepted solution]

Hi @Anonymous 

Create a measure and use that in the line value of the Constant line section:
You need to use the Conditional formatting fx:

In the Value - Apply setting to, select your measure

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/

[amitchandak · Accepted solution]

@Anonymous , If you are using an X-axis/Y-axis constant line in the analytics pane, there is an option of fx(under the line in the new pane) , You can have a measure which can change base on selected country and use that there.

If country is part of the visual you can have a measure in clustered bar and line visual  as line

measure = calculate(sum(Table[Target]), filter(Allselected(Table), Table[Country] = max(Table[Country] ) ))