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

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.

  • ctelya's avatar
    ctelya
    Frequent Visitor
    9 years ago

    Thanks so much Jared!