Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

melany

Visuals with DAX date based filters cannot load the data in Power BI Service

Submitted by Advocate I on ‎02-14-2023 12:43 PM

Just this morning, some reports that have been using DAX for date based filters suddenly cannot display the visual.  These visuals do work in PBI Desktop.  Once published to the serivce, they work for less than a minute.  Below is an example of what happens when the visual has this filter: 

IsCurrentQuarter = IF(QUARTER(Date[Date]) = QUARTER(TODAY()) && YEAR(Date[Date])=YEAR(TODAY()),"Y","N" )

melany_0-1676407089654.png

Was there an update to PBI Serice that is rendering date-based DAX filters unusable?

 

Status: Investigating
See more ideas labeled with:
2 Comments (2 New)
Comments
Anonymous
Not applicable
‎02-15-2023 05:00 AM

Hi  @melany ,

 

Does the same problem exist in Power BI Desktop?
Have these reports worked properly in the past?
Please provide us with your PowerBI Service version information.

 

Best Regards,
Community Support Team _ Caitlyn

 

melany
Advocate I
Advocate I
‎02-15-2023 05:45 AM

Hi @Anonymous 

In Power BI Desktop, there is no problem.
Yes, the reports have worked properly in the past.
Service version13.0.20105.44 .

Thanks
Melany

Idea Statuses