Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi,
I'd like to ask for help please.
I have a table table1 which contains "Sprint name" column and is used in slicer.
I have another table table2 which is summarized/filter from table1. I want to use the selectedvalue from slicer to be able to filter my table2 but with a different value:
filter(table2, table2[index] <= (select index from table2 where [table2]sprintname = selectedvalue(table1[sprintname]))
I'm not certain how to do the one in bold. When i create a var as part of table2 query:
var sprintName = selectedvalue(table1[sprintname]) <- this one doesnt seem to pick up any value
but when i create a measure under table2, i am able to get the selectedvalue but i'm not able to access it as filter in the table2 query (where measure was created).
Thanks so much!
Have you tried just =, instead of <=? The SelectedValue is a text value, right?
--Nate
Hi! Unfortnulately, no that doesn't work.
I wanted to filter may table2 based on the selected value from slicer in table1
If I hard code sprint name below it works:
Hi @Anonymous ,
Currently it is not supported to pass selected slicer values to a calculated table in Power BI, use selectedvalue() would return all blank value.
If write like calculate(max('Table'[Name]),allselected('Table')), it would return the max name value from the table.
You have need to make hard code for the calculated table to filter it.
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
15 | |
11 | |
8 | |
8 | |
7 |
User | Count |
---|---|
14 | |
13 | |
9 | |
7 | |
6 |