Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Visual Interaction per Column (measure) in combo chart

Hi All,

I am using a "line and clustered column chart" (combo chart) on column i have placed "CSAT Surveys" and "DSAT Surveys" on X axis i have a dimension let say its "Months" e.g. (Jan-19,Feb-19, Mar-19...). Now when i click on "CSAT Surveys" or "DSAT Surveys" column in the visual the visual doesnt filter based on what i clicked on "CSAT Surveys" for the month on the X axis but filters "CSAT Surveys" + "DSAT Surveys" for the month on X axis. As a user i expect the visual to filter based on what i clicked on.

I and user is expecting for interaction where if he clicks on CSAT survey it should only filter visuals for CSAT surveys for the month (dimension) on X axis.

Can someone help me here ? is it something very basic which i am missing?

Need Help
Show and Tell

3 Replies

  • vivran22's avatar
    vivran22
    Community Champion
    6 years ago

    Hello Anonymous 

     

    This functionality depends on how is the data table structured.

     

    If the two fields (CSAT & DSAT) are in two different columns, then getting the desired view would be tricky (and I guess not possible)

     

     

    But if you structure the data table such that your attributes (CSAT & DSAT) are in one column and the corresponding values in other, then you can achieve the desired output:

     

     

    Regards,
    Vivek

    If it helps, please mark it as a solution

    Kudos would be a cherry on the top 🙂

    https://www.vivran.in/

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi,

      My data is structure as per your first example.

      1. There is no "value" column. I am just 
      2. The SAT and DSAT surveys are in different columns.

       

      Regards

      Shariq

      • vivran22's avatar
        vivran22
        Community Champion
        6 years ago

        Anonymous 

         

        In that case, you need to make the change in the date table.

         

        You can use Power Query's Unpivot Column option to transform the table.

        Select the two columns > Transform > Unpivot Columns

         

        Regards,
        Vivek

        If it helps, please mark it as a solution

        Kudos would be a cherry on the top 🙂

        https://www.vivran.in/