Forum Discussion
Sales evolution through time
At the end I created a new meassure that is Year-Month, and then sorted alphabetically. I don't like it, but for now it does the job.
At the end I solved it with a date table with the information about the months, quarters, financial years, etc.
It's not ideal and tableau does it automatically, but it solved the issue! Using a date table is extremely useful.
Hi, Anonymous
Based on your description, I created data to reproduce your scenario.
You can create two column as follows.
Month-Year = FORMAT('Table'[Date],"YYYY-MM")
WeekOfYear = FORMAT('Table'[Date],"YYYY - \WeekWW")
Then you can create three ‘clustered bar chart’ visuals and a ‘matrix’ visual as below. Finally, you may see evolution on the sales by weeks or months with the slicer.
If I misunderstand your thought, please show me your expected output. I am glad to solve the problem for you. Here is my pbix
Best Regards,
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes something like this is what I want, but there is no other way through the normal visualizations? In Tableau you can group them in weeks, months, etc, so you can easily see the evolution.
I need something like the below, but I can't seem to be able to obtain a chart like the below.
And this is what I get from my data, I get the months, but they are combined of 2017 and 2018. I would like to see January to December 2017 and then January to December 2018:
Anonymous I was able to create this with a line chart, with Date on the Axis, Product as the Legend, and Value as Values.
I believe this is what you're looking for?
Yes, even combined would have been nice. Did you use any particular calculated fields or just with the normal visualization options? How did you achieve it?
Thanks