Google Analytics - date slicer only has year

[paulwozniak]

I have Google Analytics set up as the only source. I have a date field, the page field and the pageviews field imported.

When I create a slicer visualization and drag the date field into it, it only lets my slice by year. I have the field selected to be a date hierarchy in this visualization.

I would expect to be able to slice by all the levels of the date hierarchy. Is this a limitation or am I doing something wrong?

[Phil_Seamark]

What visual are you using?  If you are using a Bar or Column chart, Power BI is giving you an automatic hierarchy.  This can be useful and you should be able to drill up and down through the hierarchy (Year -> Quarter -> Month -> Day) etc.

You can turn this off by selecting the date measure where you dropped it in the report builder menu for the visual and change the setting there.

[paulwozniak]

I'm using the 'Slicer' vizualization and when the Date Hierarchy is selected it only gives me the Year value.

Indeed when I use one of the charts you mention I get the full date hierarchy, but not when I use the 'Slicer' visualization.

[Phil_Seamark]

That's because you are still using the automatic date hierarchy. In the image you posted. Click the line above Date Hierarchy. So make sure the green tick is next to "Date"

[pqian · Accepted solution]

@Phil_Seamark, I think what @paulwozniak wants is hierarchical slicers (vs individual values), which isn't available today.

You can goto the Queries Editor, and bring Month and Day of the Month dimensions in from the Time folder. They won't affect your filters on ga:date.

Alternatively, you can add a calculated column with things like MONTH([date])

[pqian]

@paulwozniak, take a look at this as well:

http://community.powerbi.com/t5/Desktop/Date-hierarchy-in-KPI-visual-contains-year-only/m-p/22281#U2...

[paulwozniak]

Thanks alot!