Forum Discussion
Advocate ISegment data by time using Days or Months in the same graph
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.
4 Replies
- asocorro
Skilled Sharer
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.).
kendashAsocorro, 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.
