Forum Discussion

Donia12215's avatar
Donia12215
Frequent Visitor
4 years ago
Solved

Line chart - line for total

I have line chart with % forecast variances for three programs and I would like to add % variance for all organisation. Forecast variances are measures based on forecasted values and actuals. Each pr...
Need Help
  • Donia12215's avatar
    Donia12215
    4 years ago

    I found solution by changing approach. Addidng it here as it might be helpfull. I created separate measures for each program and then created line chart with no legend but with four measures in values.

     

    X Forecast var % = CALCULATE([Forecast var %], Programs[Program]="X")

    Y Forecast var % = CALCULATE([Forecast var %], Programs[Program]="Y")

    Z Forecast var % = CALCULATE([Forecast var %], Programs[Program]="Z")

     

    Values in line chart:
    Forecast var %
    X Forecast var %
    Y Forecast var %
    Z Forecast var %

     

     

Donia12215's avatar
Donia12215
Frequent Visitor
4 years ago

I found solution by changing approach. Addidng it here as it might be helpfull. I created separate measures for each program and then created line chart with no legend but with four measures in values.

 

X Forecast var % = CALCULATE([Forecast var %], Programs[Program]="X")

Y Forecast var % = CALCULATE([Forecast var %], Programs[Program]="Y")

Z Forecast var % = CALCULATE([Forecast var %], Programs[Program]="Z")

 

Values in line chart:
Forecast var %
X Forecast var %
Y Forecast var %
Z Forecast var %