Forum Discussion

ashmitp869's avatar
ashmitp869
Responsive Resident
9 months ago

Help with Linear Trend line ?

Hi, Help me to get the trend line like below .   I have used LINESTX but I am getting the result below. I have attached my sample pbix file. https://github.com/suvechha/samp...
Need Help
ashmitp869's avatar
ashmitp869
Responsive Resident
8 months ago

Hi Ritaf1983 Syndicate_Admin v-tejrama 
Thanks for your solution.

But when I am using this dax expression. I am getting the trendline like below. Not as expected what you shared.
Why this is different when I implement in my pbix file ?

DL Validation Trend
Infringements Trend



 

ashmitp869's avatar
ashmitp869
Responsive Resident
8 months ago

When I check the data in table format.

Your Trends line is different than mine, even the data are same.
Suggested 

My report data

What is the reason for this ? What else do I need to change ?





  • Ritaf1983's avatar
    Ritaf1983
    Super User
    8 months ago

    Hi ashmitp869 
    If the result is not identical, it means you are not working one-to-one as I instructed.
    I attached your PBIX with the updates from the previous solution and am attaching it again.
    Aside from a strong recommendation to download it and follow up on the changes I made, unfortunately I don’t have much more to offer on this matter.

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