Forum Discussion

ctelya's avatar
ctelya
Frequent Visitor
9 years ago
Solved

Show All Months Available on Graphs

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's avatar
    Anonymous
    9 years ago

    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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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.