Forum Discussion

CeleneBenjamin's avatar
CeleneBenjamin
Regular Visitor
5 months ago
Solved

Force a default filter into drill through

Hello   We have a clustered column chart where there’s a column for each month end in the last 12 months and it shows the performance for a particular measure (see screenshot). One of the columns i...
  • johnt75's avatar
    5 months ago

    You could try creating a calculation group and applying that as a filter on the drill through page. The calculation item could check for the presence of a filter on the date table and if one doesn't exist then apply the filter you need. Something like

    Apply default filter =
    IF (
        NOT ISFILTERED ( 'Date' ),
        CALCULATE ( SELECTEDMEASURE (), 'Date'[Date] = TODAY () ),
        SELECTEDMEASURE ()
    )
    
  • Anonymous's avatar
    Anonymous
    5 months ago

    Hi CeleneBenjamin,

     

    Thank you for reaching out to the Microsoft Fabric Forum Community.

    We tried to reproduce the scenario. Please refer to the attached PBIX file for details.

    Thank you.