Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

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

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

kazun909_0-1633854634658.png

 

1 ACCEPTED SOLUTION

@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],
        ", "
    )
)

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

View solution in original post

8 REPLIES 8
benanic
Frequent Visitor

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. 
 

Anonymous
Not applicable

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

 

@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],
        ", "
    )
)

 

Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Anonymous
Not applicable

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]
    )
)
VahidDM
Super User
Super User

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!!

 

Anonymous
Not applicable

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

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!!

 

Fowmy
Super User
Super User

@Anonymous 

You a measure as follows:

SelectedStatus = SELECTEDVALUE( TableName[Status] )
Did I answer your question? Mark my post as a solution! and hit thumbs up


Subscribe and learn Power BI from these videos

Website LinkedIn PBI User Group

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.