Forum Discussion
Create Bar Chart That Compares Counts Of Values Across Multiple Columns
Thanks for the response Ashish_Mathur ! That seems to have solved my problem. However, by unpivoting the data, that seemed to have messed up the visualizations i had that were based on the data before being unpivoted. I must also add that the table described above actually has many more columns in it (probably 30 or so) that i do NOT want included in this chart visual (But are relevant for other visualization on my dashboard). In order to unpivot, it made sense to "Choose columns" and reduce the set of data to unpivot to only filter down to the columns that i want to unpivot).
Does this mean i need multiple queries so some visualizations can be based on the unpivoted data, and others will be based on the normal set?
Hi JDpowerBI,
Perhaps you can try to duplicate the original query table and do unpivot columns on it, save changes and return to the data view side. (you can use the category column as the relationship key to link both two tables)
After these steps, you can simply create visuals based on two table fields and do interaction between different visuals.
Regards,
Xiaoxin Sheng