Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Count Values In Each Row (4 options) need it for stack bar chart

Hello,   I have a ticketing system I made with four options currently. ABF, GPON, Light Green and Not available on each address that is submitted for review. My data is coming from a sharepoint li...
tamerj1's avatar
tamerj1
Community Champion
4 years ago

Anonymous 

best option is to unpivot the 40 columns using power query. Once done the rest is simple. 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

tamerj1 

Stupid question.. how do I do that? 

 

What I was trying to do now was take each column something like 

Calculate(Countrows( Table name ( column ) = "ABF") 

 

But if this is easier I will totally do it! You have no idea how much you are helping me. 

 

  • tamerj1's avatar
    tamerj1
    Community Champion
    4 years ago

    Anonymous 

    Open the query editor.

    Select the 40 columns > right click > select unpivot

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      I tried to take your advice but it broke my query. I had to contact microsoft and they could not figure it out. Do you have another option that you know of to be able to  look at the filters for each column and give me a total such as this? I have 40 columns 

      • tamerj1's avatar
        tamerj1
        Community Champion
        4 years ago

        Anonymous 

        So sorry for that!

        nothing in my mind now. I will thibk it over again and let you know if any solution comes to my mind.