Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I have some calculated fields named "CY_sales", "LY_sales", and so on, linked to a date table.
Is there any way I can substitute the field name by a variable to be shown as every column header in tables and matrix?
Id like to show "2020" instead of "CY_sales", and get it changed to "2021" next year.
Thanks,
Solved! Go to Solution.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsRegards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsUnderstood, but I can't use this solution because the matrix has CY, LY, LL, TTM columns, so the title can't refer to any specific period.
Thanks anyhow.
Hi @jmvidal ,
Your title could be a dinamyc one that says 2020 sales vs 2019 something similar. But just an idea.
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsI guess I could also add a text box with the meaning of the columns: "CY:2020 LY:2019" being the number of the year dynamic.
Thanks,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
82 | |
74 | |
66 |
User | Count |
---|---|
121 | |
105 | |
102 | |
82 | |
72 |