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

You can use your measure 'Actual incl Projected' with no change, you will need to create a new measure which will restrict your date range.
 
Cut Off =
CALCULATE(
    [Running Forecast] (Replace with [Actual incl Projected]),
    ALL('Calendar'[Week Number]),
    'Calendar'[Rolling Financial Year] = 0 && 'Calendar'[Week Number] <= 29
)

 

Here you will need to change the red highlighted area to filter to your criteria. I do not know what attributes you have avaliable to you however i would suggest using something that will make this dynamic.

 

ArchStanton's avatar
ArchStanton
Power Participant
1 year ago

Thanks.
I've modified your code to this but nothing changes on the visual:

 

Cut Off = 
    CALCULATE(
        [Actual incl Projected],
        ALL('Date'[Calendar Week]),
        'Date'[Yr & Mth Number] = 202408 && 'Date'[Calendar Week] < 24
    )

 

 

I tried to change the Cut Off Marker colour from dark green to something brighter but it does not appear in the series drop-down options.
Something tells me i'm not a million miles away from solving this with your help. 

The Red values have been conditionally formatted on a calculated column I created that provides Past or Future values. 

I tried using that in place of your  'Calendar'[Rolling Financial Year] = 0

here but I get an error message:

Cut Off =
   

 

Cut Off = 
    CALCULATE(
        [Actual incl Projected],
        ALL('Date'[Calendar Week]),
        'Modelling'[PastorFuture] = "Past" && 'Date'[Calendar Week] < 24