Date Sllicer completely broken

[lcasey]

Seriously,

I am so annoyed at Power BI developers. How they get away with the terrible and untested programing they do is just not understandable to me. How can Power BI even survive if it simply cant work with dates?

In every single report we have, if we use the date slicer in anything OTHER than list mode the dates simply do not work!!

So annoying to work with half A$$ software!!! I am pulling my hair out becouse I cant create 1 simple accurate report using Power BI

[Bokazoit]

Since I have no issues with the dates in sliders I think You need to look into whatever it is You are doing wrong. Perhaps it is not bad programming but bad us of the product?

[lcasey]

I confirmed with Premier support that this is a bug when using reports in Direct query mode.  The date slicer works great in Import mode. What Microsoft does not realize is the Direct Query mode is a MUST for financial reporting and clients simply will not accept reports developed in Import mode with only 8 refreshes a day.

It seems that almost all bugs in this product happen when using Direct query. I am assuming the developers dont pay attention to Direct Query mode as much as they do Import mode.  But this is abslutely yet another bug.

[v-qiuyu-msft]

Hi @lcasey,

I can reproduce this issue on my side. I already reported this issue internally, will update here once I get any information from product team.

Thanks for your feedback.

Best Regards,
Qiuyun Yu

[lcasey]

Thanks Qiuyun!

Sorry for the frustration,  I am struggling with DAX itself and learning a new formula language. I have years of SQL under my belt and I simply cant grasp the way DAX totals , etc.. The basic concept is not drilled in my head yet.  So when I ran into another issue with the dates I pretty much got soo Frustrated.  I am so far behind in report development. This is the first project I have ever fallen so far behind on in my 8 years contracting with this client.

Thanks for looking into this and I will keep a lookout for any further info.

[v-qiuyu-msft · Accepted solution]

Hi @lcasey,

I got the feedback from product team, they said:

This is fixed and checked in. Should be out in SU01 (Jan) release

Also there is a article which introduces DAX basics you can go through: DAX basics in Power BI Desktop.  If you have any question when you use Power BI, you can post threads in forums, many communities and us will help you.

Best Regards,
Qiuyun Yu

[Bokazoit]

Ahh I do not use Direct Query so that is the reason I have not seen this issue. I agree it is importent that every feature works whatever method is used 😉