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
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/