Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Line chart issue with running totals

Hello,   I created this Power BI chart: Almost right, but one of the numbers (36,994) is incorrect. Desired output (from Tableau): I understand what is happening: bottom line ("Actual...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    You have written available budget as a calculated column formula.  Write that as a measure instead.  This is the result you will see

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

You should ideally have a Calendar Table with calculated columns for Year, Month name and Month number.  Sort the Month name by the Month number.  Create a relationship from the Date column of the Overhead_New table to the Date column of the Calendar Table.  To your visual, drag Year and Month Name from the Calendar Table.  Write these measures

Initial Budget = sum([Initial Budget calc])

Actuals (hours) = calculate(sum([Actuals calc]),datesytd(calendar[date],"31/12"))

Available Budget = [Initial Budget]-[Actuals (hours)]

Hope this helps.

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Thank you Asish for your help. I did as you suggested but no luck:

 

 

 

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    5 years ago

    I cannot help without seeing your file.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Thank you Ashish for your help.

      I want to upload a file but I cannot see any option to do it. I can only copy/paste images but not attach a pbix file.

      I found some instructions on forums saying I should use a file sharing service (OneDrive) but our company blocks access to these sites.