Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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,
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |