Filters not working with date hierarchy in Power BI

09/21/20 Edited 09/28/20
Answered - Pending Review

I'm working on a cumulative sales by Dates. To achieve this, I followed below steps -

  1. Create Date dimension with calender(startdate,enddate) function
  2. Map Date table and Sales table with bidirectional many to one relationship (tried single directional too)
  3. Create cumulative sales measure (replace blank sum(sales) with 0 for non working days)
  4. 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.

https://mindmajix.com/power-bi-training

Any idea on why this issue is arising and how to solve?

Answers

Sign In or Register to comment.