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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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...

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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