Forum Discussion
Petuli21
6 years agoNew 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. ...
kentyler
6 years agoSolution 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