Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Most Effective Visual TO compare two columns of data.

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?

 

 

General Comment
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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 

5 Replies

  • Pragati11's avatar
    Pragati11
    Icon for Super User rankSuper User
    6 years ago

    HI Anonymous ,

     

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

     

    Thanks,

    Pragati

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

       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's avatar
        Pragati11
        Icon for Super User rankSuper User
        6 years ago

        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