Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hi Everyone ,
I would like to have 1 dashboard which identify each customer over the year from Jan to Oct 2022 , whether this customer is having sales trend down or increasing ? if any customer having sales trend down , i would like to flag this up. So people would be able to know that , The sales of this customers is coming down. I have no view of how this can be made and calculated by flagging those .
Can anyone sharing me the best practice and sample of how to analyze quickly on each customer ?
Thank you for your help
Solved! Go to Solution.
Hi,
Thank you for your feedback.
I think I did not clearly describe my thoughts. What I mentioned was that what is your definition of Trend Down?
By weekly moving average does not tell clearly.
I tried to create a sample pbix file like below and the attached file, and please define which cusomter shows Trend UP and which customer shows Trend Down. And then, some measures can be created to flag.
Or, please share your sample pbix file's link.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Hi,
In my opinion, it depends on how you or stakeholders define what is considered as Trend Down.
For instance, my team in the company defines this like below.
- compare monthly average quantity between Jan2022~previousmonth of the last complete month 2022 (in this case, Aug.2022) VS. Last complete month 2022 ( in this case, Sep2022)
I also heard from other teams in different companies and they define like below.
- compare Jan.2022 VS. Last complete month
I believe one of the correct ways to define Trend Down is, ask stakeholders what they want to see on the Power BI report.
I hope this helps.
Thank you.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
hi @Jihwan_Kim , thanks for your idea ,
i had discussed with the team to go with weekly moving average , But i'm curious , since in Power BI i have 1000 Customers , so i wanna count those who has sales trend down as of Now , i will also set the color back ground to quickly notice it.
how can i able to do that ?
Hi,
Thank you for your feedback.
I think I did not clearly describe my thoughts. What I mentioned was that what is your definition of Trend Down?
By weekly moving average does not tell clearly.
I tried to create a sample pbix file like below and the attached file, and please define which cusomter shows Trend UP and which customer shows Trend Down. And then, some measures can be created to flag.
Or, please share your sample pbix file's link.
If this post helps, then please consider accepting it as the solution to help other members find it faster, and give a big thumbs up.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
103 | |
98 | |
98 | |
38 | |
37 |
User | Count |
---|---|
152 | |
121 | |
73 | |
71 | |
63 |