Forum Discussion
Helper IGoogle Analytics - date slicer only has year
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])
Microsoft EmployeeWhat 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.
Helper II'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"
pqianPhil_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: