Forum Discussion

Mercovito's avatar
Mercovito
Frequent Visitor
2 years ago
Solved

Show Filter Context value

Hello All

 

Is it possible to get "filter context" value? For example, when I click on a slice with the value "USA" of a Pie Chart, the visuals will be filtered according to "Active". Here our Filter Context Value is "USA".


Is there any tool, power, DAX expression etc.. which shows the current Filter Context value?

 

Great thx in advance !

Need Help
  • serpiva64's avatar
    serpiva64
    2 years ago

    Hi,

    you can use something like this

    SelectedValue = SELECTEDVALUE('Table'[Column1], "More then one Product selected")

    or 

    AllSelected = CONCATENATEX(ALLSELECTED('Table'[Column1]), 'Table'[Column1], ", ")

     

    If this post is useful to help you to solve your issue consider giving the post a thumbs up 

     and accepting it as a solution !

2 Replies

  • serpiva64's avatar
    serpiva64
    Solution Sage
    2 years ago

    Hi,

    you can use something like this

    SelectedValue = SELECTEDVALUE('Table'[Column1], "More then one Product selected")

    or 

    AllSelected = CONCATENATEX(ALLSELECTED('Table'[Column1]), 'Table'[Column1], ", ")

     

    If this post is useful to help you to solve your issue consider giving the post a thumbs up 

     and accepting it as a solution !