Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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] ) ))
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/
Hello. I am trying the formula, is this correct?
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/
@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] ) ))
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
82 | |
70 | |
60 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |