Add a bar to a clustered column chart

[LeonidStoychev]

Hello, [I have a clustered column chart, where I track the actual volume vs the rolling forecast for top 10 products.

I use a few simple measures: 

2024 ACT Units = CALCULATE(SUM(data[UNITS]),'data'[Scenario]="2024 ACT",'Data'[Year1]=YEAR(Today()))/1000

2024 RFJAN Units = CALCULATE(SUM(data[Units]),'data'[Scenario]="2024 RFJAN",'Data'[Year1]=YEAR(Today()))/1000

Volume changes = [2024 ACT Units]-[2024 RFJAN Units]

Volume Variance Absolute = ABS([Volume changes]) - to get the top 10 absolute variances (both positive and negative).

Now I want to add Total Rolling forecast units in the beginning of the chart and Total Actual units at the end of the chart:

Is it possible in power BI?

Thank you.

[TomMartens · Accepted solution]

Hey @LeonidStoychev ,

unfortunately this is not possible using the default Power BI visuals, because measures can not be used on an axis value.
But you can achieve this using the custom visual Deneb, but this requirese some kind of coding, Deneb is available from app source: Deneb: Declarative Visualization in Power BI (microsoft.com)

Hopefully, this helps to tackle your challenge.

Regards,

Tom