Forum Discussion

callenbkd's avatar
callenbkd
Icon for Helper II rankHelper II
1 year ago
Solved

Line Chart with Two Lines and One only displaying data for Months selected

I'm trying to create a line chart that compares actuals to budget by month.    I want the actual months to only show the line for the months from 1 to the month selected whereas the budget data wou...
Need Help
  • parry2k's avatar
    parry2k
    1 year ago

    callenbkd good solution from gmsamborn but to avoid flat line for actual, use following measure:

     

    Actual YTD = 
    CALCULATE(
        [Actual],
        DATESYTD ( 
            CALCULATETABLE ( VALUES ( 'Date'[Date] ),  'Date'[MonthNo] <= MAX( 'Month'[Month] ) ) 
         )
    )
v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
1 year ago

Hi callenbkd,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you parry2k and gmsamborn for the prompt response.

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

 

Thanks and regards,

Anjan Kumar Chippa

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
1 year ago

Hi @callenbkd,

 

We wanted to kindly follow up to check if the solution provided by the super user resolved your issue.

If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

 

Thanks and regards,

Anjan Kumar Chippa

  • v-achippa's avatar
    v-achippa
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi @callenbkd,

     

    As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
    If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.

     

    Thanks and regards,

    Anjan Kumar Chippa