Show All Months Available on Graphs

[ctelya]

Hi,

I have data from the middle of last year to present. I'm attempting to show all the data on one graph (trailing), but cannot seem to make it work. It automatically separates the data by year and I have to drill down in order to see the months. I need to see all the months I have though. Any help would be much appreciated! I'm new to Power BI and still trying to navigate all of the tools. 

Thanks in advance!

Christina

[Anonymous · Accepted solution]

Hi @ctelya, is the field you are bringing on to the axis a date field (formatted as a date in the data model)? If so, Power BI will automatically create a hierarchy. Once you drag in your field, you can click the down arrow next to it and select either "Date hierarchy" or the field name itself. If you select the field name, it will use whatever granularity the field is at.

[ctelya]

Thanks so much Jared!