Forum Discussion
CeleneBenjamin
5 months agoRegular Visitor
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...
- 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 () ) - Anonymous5 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.
Anonymous
5 months agoNot applicable
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.
CeleneBenjamin
4 months agoRegular Visitor
Thank you - I'll have a look at this file.