Filters not working with date hierarchy in Power BI

Maxwell Gren

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?

Genevieve P.

Hi @Maxwell Gren

It sounds like your question is more suited to the Power BI Community (see here).

If you have a question relating to a Smartsheet function, it would be useful to see some screen captures, but please block out any sensitive data. Or, if you are having technical issues with Smartsheet, you can contact our Support team through this page (see here).

Cheers!

Genevieve