Forum Discussion
Dynamic Column calculation based on Slicer Selection
Dragging any date into a visual will create a date hierarchy, as long as its a date format.
or alternatively it is best practise to create a date table and then you can also create your own hierarchies.
but to start simply drag your date that is in a date format onto your visual object and then you can toggle between the date without a hierarchy and the date with. The default date hiearchy is a y/q/m/d so if you want week its best to add a date table into your pbix and then create a relationship between your date and the date table.
this is one way of creating the date table
https://www.mattmasson.com/2014/02/creating-a-date-dimension-with-a-power-query-script/
in the picture below you can see i dragged my date onto my axis and it gives me the option to choose between the hierarchy and the date.
when you use the hierarchy you can use the drill down to navigate through the hierarchy you will find it in the top left of the visual.
Dragging any date into a visual will create a date hierarchy, as long as its a date format.
or alternatively it is best practise to create a date table and then you can also create your own hierarchies.
but to start simply drag your date that is in a date format onto your visual object and then you can toggle between the date without a hierarchy and the date with. The default date hiearchy is a y/q/m/d so if you want week its best to add a date table into your pbix and then create a relationship between your date and the date table.
this is one way of creating the date table
https://www.mattmasson.com/2014/02/creating-a-date-dimension-with-a-power-query-script/
in the picture below you can see i dragged my date onto my axis and it gives me the option to choose between the hierarchy and the date.
when you use the hierarchy you can use the drill down to navigate through the hierarchy you will find it in the top left of the visual.