Forum Discussion
Gondi63
Helper I
3 years agoBottom 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...
TomMartens
Super User
3 years agoHey 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
- Gondi633 years ago
Helper I
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.
- Gondi633 years ago
Helper I
Hi TomMartens - Hopeful that you see this and can walk me through it! Thanks!
- TomMartens3 years ago
Super User
Hey,
not sure if I will find time these days, but I will have a closer look during the next weekend.
Regards,
Tom