Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
I want to setup labels that will change based on filter settings but be table driven so I can have multiple labels change with a single measure.
Visual 1: Type: Card, Name: "Card1"
Visual 2: Type: Card, Name: "Card2"
Table:
Card Name | Card Text | Language |
Card1 | Card One | English |
Card1 | Card Uno | Spanish |
Card2 | Card Two | English |
Card2 | Card Dos | Spanish |
I will use a slicer to select the language option.
Measure?
Something Like: CardName=LookupValue(Table[Card Text], Table[Card Name], <insert visual reference>)
This way I can have two (or three, or six, or whatever) cards use the same measure without creating a plethora of meaures.
Is this even possible?
I take it what I asked isn't possible? I wanted to reference the name of the visual to use in the measure so that I could use a single measure for all of the visuals. And so I can use the table for the text being displayed. If I add a dozen visuals to be translated I don't want a custom measure for each one. I want this table driven. That way I can add languages and cards as needed.
Apologies if I misunderstood your ask.
Honestly, I am unable to wrap my head around what you want to accomplish. I simply thought you wanted to change the Card's Title based on the Language selected. Sounds as if you are wanting to do something different.
I am not aware of any way to reference a visual in a Measure.
Again my apologies for the mis-understanding.
Regards,
Use can use the Card Visual's Conditional Formatting functionality. This works in much the same way as Conditional Formatting.
Create a Measure such as this:
Title_Card1 = IF( SELECTEDVALUE( 'Language'[Language] ) = "English", "CARD 1", "CARD UNO" )
This assumes you have a table for your languages
Language |
English |
Spanish |
Once you select the fx for the Title, navigate to the Measure above.
The Title will change based on the Slicer Language selected by the User.
Hope this works for you.
Regards,