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.
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.