Forum Discussion
Excellove15
Feb 01, 2024Iron Contributor
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...
- Feb 01, 2024
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
Excellove15
Feb 19, 2024Iron Contributor
Hi SergeiBaklan
Apologise for the delay, & thanks for your quick response!
This really worked like a wonder and thanks for the awesome solution
You always come to my rescue and thanks once again!
Please let me know if i can do anything for you
SergeiBaklan
Feb 19, 2024MVP
Excellove15 , you are welcome, glad to help