Forum Discussion
Merging two slicers with field parameters
- Anonymous2 years ago
Hi, UditJ
Thank you very much for your reply. The main function of this sync column is to establish a connection with another parameter table, so as to achieve synchronous filtering. This is just one of the ways.
Best Regards
Jianpeng Li
Hi, UditJ
Based on your description, I have created the following sample data:
I created two field paramertes as shown in the image below:
I'm using these two parameters in the table visual, as shown in the following image:
I created a sync column with the following DAX:
Sync column =
SWITCH (
'Previous Value'[Previous Value],
"Previous Month CPM Value", "CPM",
"Previous Month CTR Value", "CTR",
"Previous Month VCR Value", "VCR",
"Previous Month CPC Value", "CPC"
)
The following relationship is established between the two parameter tables:
Here are the results:
When I select the option for one of the slicers, both columns are updated at the same time. I've provided the PBIX file used this time below.
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- UditJ2 years ago
Helper III
and what if there is a third column? will be doing the same creating sync column ?
- Anonymous2 years agoNot applicable
Hi, UditJ
Thank you very much for your reply. The main function of this sync column is to establish a connection with another parameter table, so as to achieve synchronous filtering. This is just one of the ways.
Best Regards
Jianpeng Li