Segment data by time using Days or Months in the same graph

[kendash]

Hi everyone,

we are using PowerBI desktop to visualize several metrics and their changes in time. What is the best way how to do it?

We have a "date" dimension, which containts Day, Month and Year information for every row. We would like to see a timeline  for different time periods - Last Week, Last Month, Last Quarter, Last Year, and more. When I create a report for Last Month or Last Quarter, seeing data by Day is fine (meaning I see data segmented by Day).

However, when I choose Last Year or more options, it would be better if the graph changed automatically to show the same date using Month dimension (meaning I want to see data only for the whole month, not for every day).

Does anyone have any idea how to do it? In general? And if it was possible to do it in a single graph.

Thank you in advance.

[asocorro]

You cannot change a chart axis dynamically (from Days to Months). However, the axis could be a date hierarchy and then you can view totals at different levels (Year, Month, etc.).  

[kendash]

Asocorro, thank you very much for your answer, very much appreciated.

May I ask you - could you be please more specific, what do you mean by "date hierarchy"? What do you suggest that we should do?

Thank you in advance.

[asocorro]

If it is a date field, when you drop it in the axis well you should see it is displayed automatically as a hierachy, and your chart will have navigation buttons.

[kendash]

Hi Asocorro,

thank you for your answer.

The strange thing is that we cannot see these options in the date hierarchy.

We download data from Google Analytics and we have a dimension Date, in this format: (dddd, MMMM d, yyyy)

However, when I use a dimension Date in the graph, for example as X-Axis, I can see only Year as an option in the Date hierarchy and no months or days.

Do you know what might be a problem?

Thanks in advance.