Forum Discussion
dpombal
7 months agoPost Partisan
Using Measures in Field Parameters Name for Dynamic Column names
Hi all: I attach sample PBIX here: https://1drv.ms/u/c/30e88b19d3b8db6e/IQAMk0w4gkaeToEqN0ZtAnWsAWN8k4xep-5vUnWMmrB9xi0?e=Q3JW3B I need to create Table/Matrix element with Dynamic column names ba...
- 7 months ago
Hi dpombal
You can’t achieve that with field parameters. Field parameter names are static—whatever is defined in the parameter table is exactly what will appear in the visual. They don’t change dynamically. To get this behavior, a separate table is needed that contains all possible column names, then use measures that reference those columns and control which one is shown based on logic.
Please see the attached pbix.
dpombal
7 months agoPost Partisan
It complicates a lot my report but it is the only option i hope in future a new option easier for dynamic column names...