topic Re: Is there a way to get the selected value inside a power bi filter pane in DAX Commands and Tips

Is there a way to get the selected value inside a power bi filter pane

Anonymous — Sun, 10 Oct 2021 08:30:47 GMT

Is there a way to get the current filter selection inside a power bi filter pane. using a DAX formula

Re: Is there a way to get the selected value inside a power bi filter pane

Fowmy — Sun, 10 Oct 2021 08:35:49 GMT

Anonymous

You a measure as follows:

SelectedStatus = SELECTEDVALUE( TableName[Status] )

Re: Is there a way to get the selected value inside a power bi filter pane

VahidDM — Sun, 10 Oct 2021 09:01:44 GMT

Hi Anonymous

You can find the selected value with the SELECTEDVALUE DAX formula. For more details, click on the below link:

https://docs.microsoft.com/en-us/dax/selectedvalue-function

Measure = SELECTEDVALUE([Status])

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

Re: Is there a way to get the selected value inside a power bi filter pane

Anonymous — Sun, 10 Oct 2021 09:02:14 GMT

Fowmy it is not coming for filter pane. it shows blank.

Re: Is there a way to get the selected value inside a power bi filter pane

Anonymous — Sun, 10 Oct 2021 09:03:46 GMT

VahidDM it is not working for the filters coming via Filter pane. My filter is coming from filter pane not from report.

Re: Is there a way to get the selected value inside a power bi filter pane

VahidDM — Sun, 10 Oct 2021 09:08:38 GMT

If it's one selection, you can use MAX([status]), then it will return the selected value in the filter pane.

Can you tell me more details about the result?

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!!

Re: Is there a way to get the selected value inside a power bi filter pane

Fowmy — Sun, 10 Oct 2021 09:30:27 GMT

Anonymous

SELECTEDVALUE works if you select only one value otherwise it shows blank. If you need to show the selection when one more items are selected the use the following measure:

SelectedStatus = IF( ISFILTERED( TableName[Status] ), CONCATENATEX( VALUES( TableName[Status]), TableName[Status], ", " ) )

Re: Is there a way to get the selected value inside a power bi filter pane

benanic — Tue, 04 Oct 2022 15:42:36 GMT

Does anyone have an update on this? The previous proposed solutions work if your value is in a slicer on the report page, but that is not what the orginal poster was asking.

I have a single value selected in the filters pane for a visual, and would like to display that selected value in a dynamic title.

Re: Is there a way to get the selected value inside a power bi filter pane

Anonymous — Fri, 10 Feb 2023 07:03:13 GMT

Thank you so much!!! I am not aware that this function only accepts 1 value. I am trying to select multiple numbers but keeps on showing blank. I did a different approach to my scenario in case someone looks for it too.

I got the lowest selected value by:

IF(

ISFILTERED( 'D-Planning Calendar'[Planning Week] ),

MINX(

VALUES( 'D-Planning Calendar'[Planning Week Number]),

'D-Planning Calendar'[Planning Week Number]

)