Forum Discussion

kendash's avatar
kendash
Icon for Advocate I rankAdvocate I
10 years ago

Segment 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 Ye...
Need Help
Tips and Tricks
asocorro's avatar
asocorro
Icon for Skilled Sharer rankSkilled Sharer
10 years ago

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's avatar
kendash
Icon for Advocate I rankAdvocate I
10 years ago

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.