Forum Discussion
Format future values in Area Chart
Hi,ArchStanton .Thank you for your reply.
I somewhat didn't understand what you need behind it , but I'm guessing that's the case, hope it helps.
create measures:M_Cumulative02 = CALCULATE(SUM('Modelling'[Cumulative]),'Modelling'[PastorFuture]="feature")ISFuture = IF(MAX('Modelling'[PastorFuture])="feature",1,0)Format your visual >Visual >Data labels>Value>Color>conditional formatting
If you want to set the color of the shadows under the line graph uniformly (set the color of all predicted value ranges uniformly to the same color), unfortunately I haven't found a suitable way to do that at the moment.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello,ajohnso2 ,thanks for your concern about this issue.
Your answer is excellent!
And I would like to share some additional solutions below.
Hi,ArchStanton .I am glad to help you.
As ajohnso2 suggested.
You only need to write the measure you want to display the expected value as two separate measures
like this.
Create a column of calculations (or measures) to be used as markers
Original Forecast02 =
VAR _firstdate =
CALCULATE(MIN('Total Closures'[Month]),
FILTER('Modelling','Modelling'[Forecast] <> BLANK() )
)
RETURN
CALCULATE(
MIN('Modelling'[Forecast]),
FILTER ('Modelling', Modelling[Month] = _firstdate &&'Modelling'[PastorFuture]="feature")
)
You need to pay attention to the order in which the fields are displayed in Y-axis; the fields below will override the fields above them.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much! this now works exactly as in your pbix file - much appreciated.
There is one more thing, is it possible to shade the area higlighted with the arrow? The projected figures are on top so it would make sense to shade these and not the ones you have done?
Hi,ArchStanton .Thank you for your reply.
I somewhat didn't understand what you need behind it , but I'm guessing that's the case, hope it helps.
create measures:M_Cumulative02 = CALCULATE(SUM('Modelling'[Cumulative]),'Modelling'[PastorFuture]="feature")ISFuture = IF(MAX('Modelling'[PastorFuture])="feature",1,0)Format your visual >Visual >Data labels>Value>Color>conditional formatting
If you want to set the color of the shadows under the line graph uniformly (set the color of all predicted value ranges uniformly to the same color), unfortunately I haven't found a suitable way to do that at the moment.
I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Carson Jian,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thats great, thank you for all of your help with this!!
Hi,ArchStanton.Thank you for your reply.
You are welcome.