Forum Discussion

AlejandroPCar's avatar
AlejandroPCar
Icon for Helper IV rankHelper IV
9 years ago
Solved

Scatter Chart with two slicers!

Hi,

 

I need some help (again). I made an awesome scatter chart that have all the measures I made before (36). So, I want put all those measures in both axis. So, I create two SWITCH functions that every one have all the measures and I cant switch them quickly through an slicer. These are [Medidas Eje X] and [Medidas Eje Y] (both have all the same 36 measures).

 

But, I want two different slicers for both axis. Beacuse now I have only one slicer that currently do its job but it changes me both axis at same time and the result is always this: (a perfect correlation).

 

 

How can I have two diferent slicers that everyone just filters its respective axis?

 

Thanks again for read me!

Need Help
  • v-ljerr-msft's avatar
    v-ljerr-msft
    9 years ago

    Hi AlejandroPCar,

     

    If I understand you correctly, you may need two separate tables("TableX" and "TableY"), each table with a column called "Measure_Name" that contains all your measure names. And you need to change your [Medidas Eje X] and [Medidas Eje Y] to use different columns for the SWITCH function like below.

     

    [Medidas Eje X] = SWITCH ( FIRSTNONBLANK ( TableX[Measure_Name], 1 ), "measure1", [measure1] ...)

    [Medidas Eje Y] = SWITCH ( FIRSTNONBLANK ( TableY[Measure_Name], 1 ), "measure1", [measure1] ...)

     

    Then you should be able to use TableX[Measure_Name] and TableY[Measure_Name] column as diferent slicers, so that everyone just filters its respective axis. :smileyhappy:

     

    Regards

5 Replies

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hi AlejandroPCar,

     

    If I understand you correctly, you may need two separate tables("TableX" and "TableY"), each table with a column called "Measure_Name" that contains all your measure names. And you need to change your [Medidas Eje X] and [Medidas Eje Y] to use different columns for the SWITCH function like below.

     

    [Medidas Eje X] = SWITCH ( FIRSTNONBLANK ( TableX[Measure_Name], 1 ), "measure1", [measure1] ...)

    [Medidas Eje Y] = SWITCH ( FIRSTNONBLANK ( TableY[Measure_Name], 1 ), "measure1", [measure1] ...)

     

    Then you should be able to use TableX[Measure_Name] and TableY[Measure_Name] column as diferent slicers, so that everyone just filters its respective axis. :smileyhappy:

     

    Regards

    • AlejandroPCar's avatar
      AlejandroPCar
      Icon for Helper IV rankHelper IV
      9 years ago

      Hi! v-ljerr-msft

       

      It works! Thanks so so so much! But I have another question If I can.

       

      In my SWITCH functions I have too much measures with differents values format. Ej. Some measures are currency values and other ones are general values and others are perentage changes.

       

      But, the SITCH function just show me in the Scatter Chart values as general.

      How can I make the SWITCH function shows its respective format value for every measure in the Scatter chart?

       

       

      Thanks again for the previous answer!

      • v-ljerr-msft's avatar
        v-ljerr-msft
        Icon for Microsoft Employee rankMicrosoft Employee
        9 years ago

        Hi AlejandroPCar,

        But, the SITCH function just show me in the Scatter Chart values as general.

        How can I make the SWITCH function shows its respective format value for every measure in the Scatter chart?

        As far as I know, it is not possible to do it currently, as a measure can only be set to a specific format for a numberic value, so the format cannot be changed dynamically in this scenario. :smileyhappy:

         

        Regards