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 is today’s performance. We have applied DAX code that enables us to show the numerator and denominator for today’s performance (by default) in card visuals when no column is selected on the chart. If someone drills through on a column or selects a column and drills through from another visual, the data shown on the drill through page is just for that month which is what we want. However, if no month has been selected on the clustered column chart and the user drills through via another visual on the page, data shown is for all months on the chart and not the default (of today). Does anyone know a way to force a default value into the drill through filter so if no month selection is made, the data shown will only be today’s data? We don’t really want to use bookmarks if we can avoid it.

 

Thanks in advance,

 

Celene

 

Need Help
  • johnt75's avatar
    johnt75
    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 ()
)

5 Replies

  • johnt75's avatar
    johnt75
    Super User
    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
    Not applicable
    5 months ago

    Hi @CeleneBenjamin,

     

    Just following up to see if the Response provided by community members were helpful in addressing the issue. if the issue still persists Feel free to reach out if you need any further clarification or assistance.

     

    Best regards,
    Prasanna Kumar

  • v-echaithra's avatar
    v-echaithra
    Community Support
    4 months ago

    Hi CeleneBenjamin ,

    We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.

    Best Regards,
    Chaithra E.