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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Petuli21
New Member

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.

Capture2.PNG

 

Anything I can do without DAX?

Thanks!

4 REPLIES 4
v-juanli-msft
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
Maggie

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

v-juanli-msft
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.

Capture9.JPG

When select Date hierarchy, you could select two-down arrow to go to next level.

Capture10.JPG

Or expand all down one level.

Capture11.JPG

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.

 

kentyler
Solution Sage
Solution Sage

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=PL7GQQXV5Z8eczWqKFMDVoHMjTcpH3tgZm

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

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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