Forum Discussion

Selia_Developer's avatar
Selia_Developer
New Member
1 year ago
Solved

Date filter greater than breaking visuals

Hi,   My powerbi desktop is not working anymore. (New or existing reports).   I'm using the latest version (Version: 2.142.928.0 64-bit (April 2025)) on a Windows 11 (Emulated using Parallels Des...
  • v-venuppu's avatar
    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.