Skip to main content
Microsoft Idea

    Power BI

    New

    Option To Pass Filter Values to any Report Expressions/DAX

    Vote (2) Share
    Sumer Singh's profile image

    Sumer Singh on 23 Jul 2021 10:33:08

    Hi Team,



    Based on the Idea : https://ideas.powerbi.com/ideas/idea/?ideaid=9b346a78-a0eb-eb11-ba5e-281878e6855d



    We should have an option to pass Filter Values to any Report Column expressions/DAX to modify it based on passed values of the filters. This will more dynamic way to handle and represent data in reporting environment.



    For Example: [Column] = IF(GetFilterValue('XYZ_Filter')='yes','Do-THIS','Do-THIS')

    Comments (1)
    Sumer Singh's profile image Profile Picture

    Sumer Singh on 23 Jul 2021 10:35:01

    RE: Option To Pass Filter Values to any Report Expressions/DAX

    We need to add or provide a function "GetFilterValue('XYZ_Filter')" in DAX.