Filters not working with date hierarchy in Power BI
I'm working on a cumulative sales by Dates. To achieve this, I followed below steps -
- Create Date dimension with calender(startdate,enddate) function
- Map Date table and Sales table with bidirectional many to one relationship (tried single directional too)
- Create cumulative sales measure (replace blank sum(sales) with 0 for non working days)
- Show cumulative sales with date[date] in table view and add slicers for year, quarter and month on report.
Everything works fine when we show the date[date] as a date hierarchy in table view. Whenever we change the setting of date[date] from view as date hierarchy to date the slicers stop working.
Any idea on why this issue is arising and how to solve?