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.
Hello,
I need help with an index line. How can i set a fixed line to my y-axis as part of my index axis. The line should be fixed at index 100 to indicate whether we are on target or not (see illustration below).
Secondly, how can I set index as percentage instead of the current number? (so 1,0 should be 100% instead).
Thank you in advance
BR, Mikkel
Solved! Go to Solution.
You can create a measure with following formula to set a fixed line.
fixed_Measure = 60
If we want the secondary axis to be percentage, we can only add column/measure which do the percentage calculation into Line values. But cannot add line which represents the sales number as below.
Best Regards,
Herbert
You can create a measure with following formula to set a fixed line.
fixed_Measure = 60
If we want the secondary axis to be percentage, we can only add column/measure which do the percentage calculation into Line values. But cannot add line which represents the sales number as below.
Best Regards,
Herbert
Thank you for your help, it worked.
BR,
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 |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |