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, ...
Need Help
Show and Tell
vivran22's avatar
vivran22
Icon for Community Champion rankCommunity 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
      Icon for Community Champion rankCommunity 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/