Forum Discussion

dpombal's avatar
dpombal
Post Partisan
7 months ago
Solved

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...
  • danextian's avatar
    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.