The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Good morning,
Is there a way I can set the value of a table to legend labels, text fields and column labels dynamically.
I have the following table:
LANGU | G1 | G2 | L1 |
English | Title of the graph 1 | Title of the graph 2 | Value 1 |
Spanish | Titulo del grafico 1 | Titulo del grafico 2 | Valor 1 |
I have a filter to choose the language with the LANGU field (the content of the report is also in two languages. Thus, when I filter it all the content is also updated,. Not only the general structure).
I am able to set the graph titles dinamically with the formula button. However I am not able to do the same thing in every field. I cannot do it in a custom textfield, I cannot set a custom name to a column used in the report, etc.
For instance, the X axis should be Gestión if the chooser is in spanish or Management if it is in english.
Does anybody know how could I achieve this?
Thank you so much!
Table/matrix headers can't be dynamic.