Forum Discussion
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...
Anonymous
best option is to unpivot the 40 columns using power query. Once done the rest is simple.
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.
Anonymous
Open the query editor.
Select the 40 columns > right click > select unpivot
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