Forum Discussion

dommyw277's avatar
dommyw277
Helper V
1 year ago
Solved

Month on Month Difference

Hi, I want to have a chart that shows me the difference month on month. I have a running total per month in the Billing field but even though i can see the monthly difference i would like a field t...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi dommyw277 

    I have attached the PBIX file at the end of the reply, which you can download and open to check the difference with your own file.

     

     

     

     

     

     

     

     

    Best Regards,

    Jayleny

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

saurav_0101's avatar
saurav_0101
Frequent Visitor
1 year ago

To display the month-over-month difference as a separate field in a Power BI bar chart, you can create a new measure to calculate the month-on-month (MoM) difference based on your running total. Here’s how:

  1. Create a MoM Difference Measure: Use the following DAX formula, which calculates the difference between the current month’s billing and the previous month’s billing:

    DAX
    MoM Difference = [Billing] - CALCULATE([Billing], DATEADD('Date'[Date], -1, MONTH))

    Here:

    • [Billing] is your running total measure.
    • DATEADD shifts the context to the previous month.

  2. Add the Measure to Your Chart:

    • Insert a bar chart and place the MoM Difference measure on the Values field.
    • You can also include [Billing] if you want to compare the running total with the MoM difference.

  3. Format the Chart (Optional): To make the difference more visible, adjust the data labels or set conditional formatting to highlight positive and negative differences.

This setup will show the month-on-month difference for each bar, giving you a clear view of monthly changes on your chart. 

 

If this answers your question, please leave a Kudos or mark it as Solution.