Forum Discussion

miii's avatar
miii
Frequent Visitor
7 years ago

One line chart for different calculations

Hi - 

 

I'm looking for a dax measure for a line chart graph to combine multiple values into one line. Currently it's showing each line for one calculation and when a specific month is selected it truns into a dot for that month, but instead I'd like to display a line for previous months and continuation of the same line to reflect forecast.

 

Need Help

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    7 years ago

    Can you provide an example of data and your current calculation? How are you doing the forecasting?

    • miii's avatar
      miii
      Frequent Visitor
      7 years ago

       

      Thanks for help Greg - This is the code being used for calculations

       

      Indirect Labor Budget YTD:=
CALCULATE(
	[Indirect Labor Budget],
	DATESYTD('Calendar'[Date])
)
      Indirect Labor Forecast YTD:=
CALCULATE(
	[Indirect Labor Forecast],
	DATESYTD('Calendar'[Date])
)
      Indirect Labor Actual YTD:=
      var maxyear = MAX('Calendar'[Relative Year Index])
      var _month = MAX(Scenario[SCENARIO_NUM])
      return
      calculate(
      CALCULATE(
      [Indirect Labor Actual],
      filter(
      'Calendar',
      and(
      'Calendar'[Relative Year Index] = maxyear , 
      'Calendar'[Month] <= _month
      )
      )
      ), 
      DATESYTD('Calendar'[Date])
      )

       

       

  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    hi, miii 

    Do you mean that when you select one specific month, there are still previous month and next month data in the chart? IF so, you don't need to select any month. When you select one month, other month will be filtered in the visual.

    If not your case, please share your sample pbix file and expected output not just the formula of measure.

    Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

     

    Best Regards,
    Lin