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

Power BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.

Reply
Aditi_R
Frequent Visitor

Using SELECTEDVALUE from a slicer to generate dynamic column

Hello everyone,

 

I have a table of  student performance (percentage marks in each subject).

I have a slicer for values 5,10,15,...,100. If the user selects the value say 40, I want to create a column which will store 1 if the percentage obtained by the student is less than 40 and 0 otherwise.

 

I tried using:

req_col = IF('dataset'[percentage] < SELECTEDVALUE('slicer'[Column1]), 10)
but it is returning 0 for every entry.
 
Any suggestions appreciated! 
Thank you in advance!
1 ACCEPTED SOLUTION
pratyashasamal
Memorable Member
Memorable Member

Hi @Aditi_R ,
I would suggest using parameters for Columns slicer and then creating a measure out of it.
You can refer to these links:-
https://learn.microsoft.com/en-us/power-query/power-query-query-parameters

https://www.sqlbi.com/articles/using-the-selectedvalue-function-in-dax/
Hope this is helpful.
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





View solution in original post

2 REPLIES 2
pratyashasamal
Memorable Member
Memorable Member

Hi @Aditi_R ,
I would suggest using parameters for Columns slicer and then creating a measure out of it.
You can refer to these links:-
https://learn.microsoft.com/en-us/power-query/power-query-query-parameters

https://www.sqlbi.com/articles/using-the-selectedvalue-function-in-dax/
Hope this is helpful.
Thanks ,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!





johnt75
Super User
Super User

Calculated columns are only calculated during data load or refresh, so they do not pay any attention to slicers or filters. If you want something which will react dynamically you will need to do it as a measure.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.