Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to Solution.
Yes, I thought it wasn't possible because PowerBI can't really handle user input data. Even though it has problems, at least it's possible
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.
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
Wow, that's a great way of solving this problem. Didn't know about it!
As it turns out, I was wrong hahaha
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.
Yes, I thought it wasn't possible because PowerBI can't really handle user input data. Even though it has problems, at least it's possible
As of now, I don't think it's possible. Maybe in a future update.
But I may be wrong!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
101 | |
72 | |
68 | |
45 |
User | Count |
---|---|
145 | |
106 | |
105 | |
90 | |
65 |