Forum Discussion
KPI visual: keeping trend axis while changing month
Hey all!
I have a question regarding the KPI visual (which really looks so fancy!).
I want to show up how much sales we've achieve in a month (chooseable via dropdown). But when I create a KPI visual and select a month the trending axis (of course) do not show up.
7 Replies
Anonymous because you filtered for a month and the trend axis don't see previous months data and that's why you are not seeing the trend.
Don't filter for a month but use relative date filter and so that you have data for last x number of months (the months you want to show on trendline) and that will get you going. Just an idea.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
parry2k Yes I know that problem, but just want to know if there is any solution for that? To show the monthly sales but also to show the whole trend axis?😁
Anonymous I gave you the solution and that's how I used it in the past and it worked. Not sure if that is not clear or you need more assistance.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
