Forum Discussion

Singhcooldeep's avatar
Singhcooldeep
Regular Visitor
1 year ago
Solved

How to create two lines in a Line Chart

I want to create two lines in a Line Chart(Only Need the data where Age is 6 for the device) 1. First line should show the count difference of the Device from previous month where Age should be only...
Tips and Tricks
  • v-venuppu's avatar
    v-venuppu
    1 year ago

    Hi Singhcooldeep ,

    Thank you for the Response..!!

    I have done the changes as per the requirement by creating updated measures, please go through the attached pbix file and refer the second chart.

     

    If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

    Thank you.

v-venuppu's avatar
v-venuppu
Community Support
1 year ago

Hi Singhcooldeep ,

Thank you for reaching out to Microsoft Fabric Community.

I have created sample .pbix file by using the sample data to replicate the scenario.

You can go through the attached file for your reference.

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.

Singhcooldeep's avatar
Singhcooldeep
Regular Visitor
1 year ago

v-venuppu Thank you for the help, I just made a little change in the 'DeviceCountDiff'
In RETURN statement i did 'PreviousCount - CurrentCount' & everyhting is working perfect for me just one thing that the 'DeviceCountDiff' line is also showing the data for June month however in my actual data i just have the data till 19-05-2025.(This data for June is actually the latest device count)