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.
https://mindmajix.com/power-bi-training
Any idea on why this issue is arising and how to solve?
Answers
-
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
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives