Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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!
Hi @Petuli21
Unfortunately proposed solutions did not help. Problems I described in the first inquiry still occur.
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
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.
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
Help when you know. Ask when you don't!
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
126 | |
78 | |
78 | |
60 | |
51 |
User | Count |
---|---|
164 | |
84 | |
68 | |
68 | |
58 |