Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Anonymous
Not applicable

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?

3 REPLIES 3
vivran22
Community Champion
Community Champion

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)

 

current.JPG

 

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:

Required.JPG

 

result.JPG

 

Regards,
Vivek

If it helps, please mark it as a solution

Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Anonymous
Not applicable

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

@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

Answer.JPG

 

Regards,
Vivek

If it helps, please mark it as a solution

Kudos would be a cherry on the top 🙂

https://www.vivran.in/

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.