Skip to main content
cancel
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.

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

PBI_APRIL_CAROUSEL1

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.