Eventually I need to change the name of the columns of a visual matrix (with measures) dynamically, according to the user's filter. For example, in a visual matrix by Category/Month, the user selected a year (2021) and a few months. I would like the title of the MoM columns to be Jan/21 vs Feb/21 and Feb/21 vs Mar21 and so on. It may sound silly but changing the column title according to a filter selection would make my work more readable because I'm currently using MoM, MoM -1, Mom -2
4 Comments
It is utterly astounding that you can't do this in Power BI. An absolute basic of reporting is last 3 - 6 months stuff. I can abstract the data model, but labelling the table columns correctly is a must!!
Provide this feature for all visuals i.e. table, multi-card etc. For multi-card, user should allowed to change category label based on some condition. Lets say, i have a slicer, i selected "A" from slicer then, i want to display "Category A" else this will be "Category Y" for my category caption.
Currently, the only way to do it is through a Field Parameter, although this means having to duplicate the field and rename it each time, which is really bad in terms of optimization.
- Status added:New
