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

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

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