Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
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
Can you provide an example of data and your current calculation? How are you doing the forecasting?
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])
)
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
77 | |
69 | |
52 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |