Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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?
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/
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
Regards,
Vivek
If it helps, please mark it as a solution
Kudos would be a cherry on the top 🙂
https://www.vivran.in/
User | Count |
---|---|
98 | |
90 | |
77 | |
71 | |
64 |
User | Count |
---|---|
114 | |
98 | |
96 | |
68 | |
67 |