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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

Dynamic Text

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?

1 ACCEPTED SOLUTION
v-xulin-mstf
Community Support
Community Support

Hi @Anonymous,

 

It is not supported, a calculate column can not get dynamic values.

Maybe you can vote here.

 

Best Regards,

Link

 

View solution in original post

4 REPLIES 4
v-xulin-mstf
Community Support
Community Support

Hi @Anonymous,

 

It is not supported, a calculate column can not get dynamic values.

Maybe you can vote here.

 

Best Regards,

Link

 

Anonymous
Not applicable

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

themistoklis
Community Champion
Community Champion

@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])

Anonymous
Not applicable

The problem with using a measure is I cannot use the measure in the rows of a matrix, legend of a chart etc

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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