Forum Discussion

UditJ's avatar
UditJ
Helper III
2 years ago
Solved

Merging two slicers with field parameters

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 

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • Anonymous's avatar
    Anonymous
    2 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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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's avatar
      UditJ
      Helper III
      2 years ago

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 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