Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
Is there a way to get the current filter selection inside a power bi filter pane. using a DAX formula
Solved! Go to 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],
", "
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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
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],
", "
)
)
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
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:
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!!
@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!!
@Anonymous
You a measure as follows:
SelectedStatus = SELECTEDVALUE( TableName[Status] )
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
17 | |
10 | |
10 | |
8 | |
6 |
User | Count |
---|---|
20 | |
18 | |
16 | |
13 | |
10 |