Forum Discussion
Reference the field parameter in dax measures to dynamically change the visuals
- 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
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
- Excellove15Feb 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
- SergeiBaklanFeb 19, 2024MVP
Excellove15 , you are welcome, glad to help