Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Count values in different columns

Hi Experts, 

 

I'm progressing in power BI, but so far did not use any single formula as it just doesn't work for me. If anyone can give me heads up: 

 

I have one simple data wich looks like that: 

 

Column 1  Column 2 

Positive      Negative 

Positive     Neutral 

Positive     No Feedback 

Positive 

Negative 

 

So on, 7 columns. I'm looking into way to create Pie chart to see % of positive, % of negative, % of neutral and so on... 

 

Any ideas? 

thanks

 
 
 

 

 
Need Help
  • Icey's avatar
    Icey
    6 years ago

    Hi Anonymous ,

     

    I suggest you to use "UnPivot" to transform your data. After that everything will be simple. Please refer to this similar post: Count value in different columns.

     

     

    Best Regards,

    Icey

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

3 Replies