Forum Discussion
Stack area chart without date hierarchy
Hi,
really new with Power BI, currently using it only with very basic knowledge (no knowledge of DAX) for visuals. I have data showing values for each day of the year in several categories.
1.1.2020 Category 1 = 1; Category 2 = 2; Category 3 = 3; total = 6
2.1.2020 Category 1 = 1; Category 2 = 2; Category 4 = 3; total = 7
I need the stack area chart to show the composition of all categories on the specific day, but x-axis formated by month. Problem is, I only get right results of composition when selecting "Date" (not "Date hierarchy"), but then I can't display months on the x-axis.
When I select Date hierarchy, chart shows sum of all the values in all categories in the specific month, but I need to show the reader the course of the month.
Anything I can do without DAX?
Thanks!
4 Replies
Hello,
I think you will need to add a calendar table. That's a table with an entry for every day in the date range covered by your report, and additional columns that tell what month, year, etc any given day is in.
There are many sample available. A good one is here: https://www.youtube.com/playlist?list=PL7GQQXV5Z8eczWqKFMDVoHMjTcpH3tgZmalong with a short video about how to use it
Once you have the calendar table you can relate it to your date field, and then you will be able to select the date, but also have the month values available.
I learn something every time I answer a question
I'm a personal power bi trainerHi Petuli21
When you select "date" for "x-axis", you can hover on the line to see its detailed information including dates and values for every category.
or under Format->X-axis, change Type from Continous to Categorical, then the X-axis show dates day by day.
When select Date hierarchy, you could select two-down arrow to go to next level.
Or expand all down one level.
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Hi Petuli21
Is this problem sloved?If it is sloved, could you kindly accept it as a solution to close this case?If not, please let me know.Best RegardsMaggieUnfortunately proposed solutions did not help. Problems I described in the first inquiry still occur.
