Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
lseite
Frequent Visitor

Error on visual with a measure not used in visual

Hello all, 

 

i have a double mystery on my BI desktop

 

1/ A visual that was working fine a few days ago is now not displaying because of a measure which is not in the visual itself...!

 

2/ it's a "DATEADD expects a contiguous selection" error, which makes no sense since the measure hasn't been changed...and is working correctly on other reports

 

has any of you already seen this kind of error ? I can't understand why it's linking my visual to a measure not used in the visual (and there are no measure in the visual which uses this "error" measure)

 

many thanks in advance

 

 

 

 

2 REPLIES 2
v-zhangti
Community Support
Community Support

Hi, @lseite 

 

Can you provide some sample data or simple pbix files? Sensitive information can be removed in advance. What kind of expected results do you expect? You can also show it with pictures.

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more.

amitchandak
Super User
Super User

@lseite , Dateadd function only work with continuous dates. So if you do not have try to use date

Days simply add

[Date]+10

 

Or

 

Date(Year([Date]) + 1, Month([Date])

 

refer how to use date as dateadd

Date as Dateadd - Decoding Date and Calendar 5-5 - Power BI Turning 5 Celebration Series
https://community.powerbi.com/t5/Community-Blog/Date-as-Dateadd-Decoding-Date-and-Calendar-5-5-Power...

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.