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 moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
92 | |
87 | |
84 | |
65 | |
49 |
User | Count |
---|---|
140 | |
114 | |
110 | |
59 | |
59 |