Forum Discussion
Solved
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...
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
I didn't dig so far, some later. As an idea you may use calculation group to substitute measures used in columns. Details are here Using calculation groups to selectively replace measures in DAX expressions - SQLBI