Forum Discussion
How to create Year, Month, Date hierarchy while creating reports in Power BI
Hi All, I have created a report in power BI, this has seperate month and year fields in a period dimension. but i have difficulties in making a hierachy for it. eg: year 2016 month January or ...
tschmidt87
Advocate I
Advocate IGet the HierarchySlicer from the Custom Visuals Gallery: https://app.powerbi.com/visuals/show/HierarchySlicer1458836712039
Add it, make sure the data field is of type "Date" and it should work as below:
You can remove certain hierarchy levels, such as "Quarter" so it only lists every month of the Year below '2016'