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,
Is it possible to create a target line in a line and graph chart which increases by 1% each month?
Thanks.
Solved! Go to Solution.
Hi @Anonymous
If you mean to add such a line in a line chart, you could refer to my test below.
base date = DATE(2019,9,1) base target = 3 increase month = DATEDIFF([base date],TODAY(),MONTH) increas target = [base target]*(1+[increase month]/100)
If
Hi @Anonymous
If you mean to add such a line in a line chart, you could refer to my test below.
base date = DATE(2019,9,1) base target = 3 increase month = DATEDIFF([base date],TODAY(),MONTH) increas target = [base target]*(1+[increase month]/100)
If
If you know the start month, let's say its Jan.
Then you can create a calculated column that divides the month number of the date by 100, which will give you .2, .3, .4 for feb mar and april etc
Then you can add that column to your graph
Help when you know. Ask when you don't!
Do you have time to do a screen share today ? I usually use Zoom. Then we can go over your problem in detail.
Help when you know. Ask when you don't!
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |