Forum Discussion
Use Slicer value as Variable
Hi, i want to have a table with calculated columns, in one column I set the value to 1 if the value is related with another table.
This works perfect but its not ver y dynamic.
So i want to know if there is a way to set for example a Slicer and use that value in the calculated column.
I mean, to use the slicer selection in the calculated column of the table.
Thank you very much.
6 Replies
Yeah, this is possible. I've used it as a janky way to set up input variables on a report before. The trick is using SELECTEDVALUE to get one value out of a list of values.
You have to explicity declare all the values that the SLICER value can be, but it works. If you wanted to get a percentage of a value in Table1 with a slicer you could do the following:
Create a table of values 0-100 called "SlicerValues". Create a slicer that slices SlicerValues[value]. Create a measure or calculated column in Table1 as appropriate with code like:
Portion of Data = Table1[Value]*SELECTEDVALUE(SlicerValues[value])/100
This has limitations, like the slicer only has whatever range you set as available, but gets the job done.
It's super unreliable, and doesn't work well unless you can enumerate all the values possible for the selection. PowerBI just isn't generally meant for on the fly dynamic calculations based on a value the report viewer sets.
Thanks Cmcmahan this is same what i am doing but is it possible to get more than 1 value is stored and used in measure. I have explained in below thread if you can provide some input that will be very helpful.
Regards
