Forum Discussion

brokencornets's avatar
brokencornets
Icon for Helper IV rankHelper IV
6 years ago

Stacked area showing zeros

Hi guys, I'm being driven insane trying to do what I thought should be a very simple task. I have an area graph showing jobs outstanding by priority over a period of time:   But as you can see...
Need Help
brokencornets's avatar
brokencornets
Icon for Helper IV rankHelper IV
6 years ago

Looks really useful, I've bookmarked the website for future. However, it doesn't (as far as I can tell) solve the issue of not being about to show the x-axis as continuous, which (given the size of my visualizations) means if I have more than 14 months of data the user will have to scroll left or right to see all the data, which is a bit of a deal-breaker.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
6 years ago

brokencornets once you drill down to the date level, you will able to change x-axis type to category and it will work. Let's be very clear here, change the table as a date table wouldn't have an impact on the visualization, you can still achieve the same, it is matter of doing it the right way.

 

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.⚡