Forum Discussion

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

How to create line graph to illustrate previous vs current month data?

Hi everyone,

 

I am working with a dataset that lists the below column headers:

- Incident Number

- Date Raised

- Status

 

I have created a table with the Date Raised separated into hierarchy year and month, as well as the count of 'Incident Number' for "Current Month" and created a Measure for "Previous Month", "Month Difference" and "MoM".

 

I am wanting to create a visual like the below, which shows the quantifying change of incidents based on their status for the current month compared to the previous month as a baseline.

Can someone please assist with how to achieve this visual? Specifically, what additional measures are required to quantify number of incidents based on their status, how to create this visual and have it recognise the current month and previous month and lastly, how to have this visual formatted as the above with two X axis values being 'previous month' and 'current month' and have the previous month's data as the baseline.

 

Thanks in advance!

  • Hi dcheng029 

    The structure of your data is not clear from the image you attached.
    So, I'll try to answer based on my own example.
    You simply place the status as the Legend.


     

     


    I'm attaching the file with the example so you can follow my steps.
    If you're still having trouble, you'll need to attach your data table in a format that can be copied, meaning not an image or screenshot, or provide a link to the PBIX file.

    How to Get Your Question Answered Quickly  

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

1 Reply

  • Hi dcheng029 

    The structure of your data is not clear from the image you attached.
    So, I'll try to answer based on my own example.
    You simply place the status as the Legend.


     

     


    I'm attaching the file with the example so you can follow my steps.
    If you're still having trouble, you'll need to attach your data table in a format that can be copied, meaning not an image or screenshot, or provide a link to the PBIX file.

    How to Get Your Question Answered Quickly  

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