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: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

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