Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreShape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.
Hey,
This seems like it should be a simple thing, but I cant see any way of doing it.
I have a few places in one of my data models where I need dynamic text columns. So there will be an unlinked table, where the users will make a selection, and on the back of that, i would like the values in a text column to change.
One example would be a filter that makes data anonymous, so they click 'Anonymous' and the names are converted to xxxx. I can't do this in a measure as then I cant use this in the rows of a matrix, legend of a chart etc.
Is there a way to do this?
Solved! Go to Solution.
Hi @Anonymous,
It is not supported, a calculate column can not get dynamic values.
Maybe you can vote here.
Best Regards,
Link
Hi @Anonymous,
It is not supported, a calculate column can not get dynamic values.
Maybe you can vote here.
Best Regards,
Link
Thank you. I have voted. Hopefully this gets implemented some time soon, as I have a ton of different applications for it, and I feel like its a big functionality gap
@Anonymous
You can try using the function SELECTEDVALUE in a measure
So if you have a slicer with Countries you can write something like this:
Measure = IF (SELECTEDVALUE(Table[Country])= 'ABCD', 'XXXX', Table[FieldValue])
The problem with using a measure is I cannot use the measure in the rows of a matrix, legend of a chart etc
Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.
User | Count |
---|---|
94 | |
92 | |
84 | |
83 | |
49 |
User | Count |
---|---|
145 | |
142 | |
111 | |
71 | |
55 |