Visual Interaction per Column (measure) in combo chart

[Anonymous]

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?

[vivran22]

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]

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]

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