Forum Discussion
Date filter greater than breaking visuals
- 1 year ago
Hi Selia_Developer ,
Thank you for reaching out to Microsoft Fabric Community.
Instead of using the > operator directly, try using NOT and < to invert the condition. Here's how to rewrite your failing query:
DEFINE VAR __DS0FilterTable =
FILTER(
KEEPFILTERS(VALUES('financials'[Date])),
NOT('financials'[Date] < DATE(2014, 12, 2))
)EVALUATE
SUMMARIZECOLUMNS(
__DS0FilterTable,
"SumProfit", IGNORE(CALCULATE(SUM('financials'[Profit])))
)Also try checking below:
1.Try changing your regional settings in Power BI Desktop (File > Options and settings > Options > Regional Settings).
2.Ensure Parallels and Windows are fully updated.
3.Consider testing on a native Windows machine to confirm if it’s an emulation issue.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Thank you.
Hi Selia_Developer ,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.
Thank you.