Forum Discussion

ArchStanton's avatar
ArchStanton
Power Participant
1 year ago
Solved

Format future values in Area Chart

Hi,   I have the following visuals that include predicted figures for September onwards: Is there any way I can:   Shade the area from Sep onwards in the Area Chart Visual to show these a...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    1 year ago

    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.



     

ajohnso2's avatar
ajohnso2
Solution Supplier
1 year ago

Hey,

There is no direct way of doing it, however you can split your measures into 2.

I.e 1 measure will plot April - September, 2nd measure will plot April - March.

You can then overlay the 2 measures on your chart effectively hiding 1 behind the other and thus enabling you to change the colours of both seperately.

  • ArchStanton's avatar
    ArchStanton
    Power Participant
    1 year ago

    Thanks for your advice. I'm not quite sure how to do this.
    My data table is below and is linked to excel. The month is many to many relationship with my Calendar table:

     

    It is the Cumulative Column that i would need to base the 2 measures for (Apr - Aug) & (Sep to Mar).

     

    The current measure for that column is just a basic Sum = 

    Actual incl Projected = SUM(Modelling[Cumulative])

     

    My Calendar Table has a Month Year Sort columns that would show 202401 (Apr) and 202405 (Aug), 202406 (Sep) to 202512 (Mar).

     

    Apr to Aug = CALCULATE(
    FILTER('Date','Date'[Month Year Sort])