Forum Discussion

Excellove15's avatar
Excellove15
Iron Contributor
Feb 01, 2024

Reference the field parameter in dax measures to dynamically change the visuals

Hi,   My requirement is to use columns from field parameter to dynamically change the visual Field parameter table is as below:   The columns Category, Category Main are calculated columns...
  • SergeiBaklan's avatar
    Feb 01, 2024

    Excellove15 

    If with fields parameter - I'd create two parameters tables, one for the measures shown in lines, and another one for the measures shown in columns.

    On the top two simple calculated tables, for the Category and Category Main used for slicers. Like this

    With that you may slice both columns and lines with the same slicers.

    I simply duplicated Parameter 2 table into Parameter 3 one. Thus the same measure in line and columns and blanks are not cleaned.

    File is here Portfolio 6 latest.pbix

Resources