Forum Discussion
Bottom 5 Trends (Slope, Linear Regression)
I have a group of locations with values over time. I'd like to highlight the locations that are trending the worst, not necessarily the locations which have the worst actual numbers. For instance, go...
Hey Gondi63
yes it's doable.
Create a pbix file that contains sample data, but still reflects your data model (tables, relationships, calculated columns, and measures). Upload the pbix to onedrive, google drive, or dropbox and share the link. If you are using Excel to create the sample data instead of the manual input method share the xlsx as well.
Regards,
Tom
Thanks TomMartens --- Here is the PBIX and dummy data file. If I were to want the 3 highest slopes of this data, I should get series A, B & C.
Hi TomMartens - Hopeful that you see this and can walk me through it! Thanks!
Hey,
not sure if I will find time these days, but I will have a closer look during the next weekend.
Regards,
Tom
