Most Effective Visual TO compare two columns of data.

[Anonymous]

Hi, 

my datasource is a table with two columns of simliar data. For each person would pick a category on Column 1 and then update their choice on Column 2. Both of these columns have 5 categories of data (all the same of  categories)and I would Like to count  how much each category appears on a single visual (single column chart) instead of doing 2 column charts. 

Is this possible?

[Pragati11]

HI @Anonymous ,

It's hard to understand and answer your query without any sample data screenshot. Can you share one here?

Thanks,

Pragati

[Anonymous]

 This is sample data on how it is shown in both power BI.

I want to compare both columns in one single visual instead of using two bar charts. Is this possible and what would be the most effective visual to do this? 

[Pragati11]

Hi @Anonymous ,

You can achieve this by appending data from TBALE 1 to TABLE 2 and creating a single table as shown below: (Make sure the Column name is same in both of your tables)

Then create a single bar chart as follows:

If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂

Thanks,

Pragati

[Anonymous]

Thanks but not quite,

I would like a visual which would allow me to compare the total count of both of these pre and post values. 

person id                         pre                          post

1                                     happy                     happy

2                                    change teams         happy

3                                      left                           left

4                                     change teams          left

Want a visual to compare the difference between Pre and Post 

Could this be done with stacked column? 

[v-yiruan-msft · Accepted solution]

Hi @Anonymous ，

Please unpivot the field "pre" and "post" firstly, then drag the fields onto clustered column chart just like below screen shots:

Unpivot columns pre and post

Create clustered column chart

Best Regards

Rena