Merging two slicers with field parameters

[UditJ]

I have two field parameters and they are put in a slicer and they are being used in a table as shown below 

These are the field parameters for the two columns in the table:

Previous Month CPC Column 

Previous Value = {

    ("Previous Month CPM", NAMEOF('CrossChannel'[Previous Month CPM Value]) , 0),

    ("Previous Month CTR", NAMEOF('CrossChannel'[Previous Month CTR Value]) ,1),

    ("Previous Month VCR", NAMEOF('CrossChannel'[Previous Month VCR Value]), 2),

    ("Previous Month CPC", NAMEOF('CrossChannel'[Previous Month CPC Value]), 3)

}

CPC Column

KPI - Performance Analysis = {

    ("CTR", NAMEOF('CrossChannel'[CTR]), 0),

    ("CPC", NAMEOF('CrossChannel'[CPC]), 1),

    ("CPM", NAMEOF('CrossChannel'[CPM]), 2),

    ("VCR", NAMEOF('CrossChannel'[VCR]), 3)

}

Above two are field paramertes are put in a sclier and as per secelction its dispalyed in the table. I want to use a single slicer to update both the columns (Previous value & CPC) in the table. any suggestions ? 


@amitchandak 

[Anonymous]

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.

[UditJ]

and what if there is a third column?  will be doing the same creating sync column ?

[Anonymous · Accepted solution]

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