Skip to main content

Power BI

New

Update Filter Selection to Include First and Last as Default Selection

Vote (1) Share
Mary Ambrose's profile image

Mary Ambrose on 27 Jul 2023 16:52:17

Please consider updating the filter ability to have a First by Default and Last by Default selection. The desired behavior is such that the First By Default would allow the user to set by numerically first or alphabetically first as a default selection from a list of values while still ensuring the ability to change from the First to some other value in the selection list. The Last By Default would have a similar behavior but using the numerically last or alphabetically last value in the list.


Problem: When faced with the need to set a report default value by a known entity the current filter capabilities make it impossible to set a default value when other filters are applied like because those other filters might limit the list to values not equal or equivalent to the default value. To be able to overcome the possibility that the entity list is not a member of another entity list, you need a default filter that acknowledges the lack of membership and resets to the First or Last where the membership between entities exists. Today, there is no way to achieve this without creating DAX that you might then need to recreate for every instance where this type of default filtering is desired. If it was an innate function - then it would eliminate the need to rebuild the filter capability each time it is needed while ensuring proper performance.