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 guys,
I have a line chart as follows and wondering if I can get solid green line (Achieved progress) up to a certain date (let's say November 30, 2021) and then followed by dotted green line (Forecast progress)?
Any help is appreciated.
Thanks,
Nilesh
Solved! Go to Solution.
Hi @jnnilesh29
Please correct me if I wrongly understand your question .
In your sample, use a certain date 2021-11-30 as the separation point , the value of Achieved progress display as a solid green line and the value of Forecast progress display as a dotted green line .You can realize the requirements by creating measures .I create a sample , you can make a reference .
(1)Create two measures to return the value of Achieved progress before the certain date and the value of Forecast progress after the certain date .
achieved progress before = CALCULATE(SUM('Table'[Achieved progress]),FILTER('Table','Table'[Date]<=DATE(2021,11,30)))
forecast progress after = CALCULATE(SUM('Table'[Forecast progress]),FILTER('Table','Table'[Date]>=DATE(2021,11,30)))
(2)Add a Line chart ,and put these two measures in Values and Secondary values ,date in Axis .
(3)In visual format , turn on Customize series in Shapes . Choose the measure [forecast progress after] and set the Line style to Dotted . Change the line color in Data colors .
The final result is as shown :
I have attached my pbix file , you can refer to it .
Best Regards
Community Support Team _ Ailsa Tao
Hi @jnnilesh29
Please correct me if I wrongly understand your question .
In your sample, use a certain date 2021-11-30 as the separation point , the value of Achieved progress display as a solid green line and the value of Forecast progress display as a dotted green line .You can realize the requirements by creating measures .I create a sample , you can make a reference .
(1)Create two measures to return the value of Achieved progress before the certain date and the value of Forecast progress after the certain date .
achieved progress before = CALCULATE(SUM('Table'[Achieved progress]),FILTER('Table','Table'[Date]<=DATE(2021,11,30)))
forecast progress after = CALCULATE(SUM('Table'[Forecast progress]),FILTER('Table','Table'[Date]>=DATE(2021,11,30)))
(2)Add a Line chart ,and put these two measures in Values and Secondary values ,date in Axis .
(3)In visual format , turn on Customize series in Shapes . Choose the measure [forecast progress after] and set the Line style to Dotted . Change the line color in Data colors .
The final result is as shown :
I have attached my pbix file , you can refer to it .
Best Regards
Community Support Team _ Ailsa Tao
You should create 2 measures per line (one for solid and one for dotted).
See link below:
Hi @themistoklis ,
I did create two measure per the link you shared. However, it is giving me some weird results. Please see the below graph and measures:
Please help.
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 |
---|---|
111 | |
94 | |
83 | |
66 | |
59 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |