Forum Discussion
Columns change to vertical lines when adding Line Value
Hi there
When I add Line Values to a line and column chart, why do the columns change to lines?
Before:
After:
Many thanks!
Anonymous are you drilling from fiscal year to date? Try two thing:
- remove fiscal year and see data by date (for testing)
- on format pane, change the x-axis to categorical than continuous
IT is not a data issue
✨ Follow us on LinkedIn
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to 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.⚡
6 Replies
- parry2kSuper User
Anonymous use stacked and line column visual
✨ Follow us on LinkedIn
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to 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.⚡
- AnonymousNot applicable
Many thanks for your reply
It's the same for both 'line and stacked column chart' and 'Line and clustered column chart'
- parry2kSuper User
Anonymous not sure why but works fine for me, do you have anything on legend/column series?
- AnonymousNot applicable
Nothing really complicated - would the Date cause issues?
- parry2kSuper User
Anonymous are you drilling from fiscal year to date? Try two thing:
- remove fiscal year and see data by date (for testing)
- on format pane, change the x-axis to categorical than continuous
IT is not a data issue
✨ Follow us on LinkedIn
Check my latest blog post Comparing Selected Client With Other Top N Clients | PeryTUS I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to 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.⚡
- AnonymousNot applicable
Changing to categorical worked! many thanks 🙂