Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

New Member

Stack area chart without date hierarchy



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?


Community Support
Community Support

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 Regards

Unfortunately proposed solutions did not help. Problems I described in the first inquiry still occur.

Community Support
Community Support

Hi @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
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.


Solution Sage
Solution Sage


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:

along 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 trainer 

Did this post answer your question? Mark it as a solution so others can find it!

Help when you know. Ask when you don't!

Join the conversation at We Talk BI find out more about me at Slow BI

Helpful resources

Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City


Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.