Pie Chart Formula Needed

[Matt_Mohawk]

I have a Pie Chart that I would like to use to control the data shown in visuals. All the other reports that I have generated have all the data in one column but this report has the data broken out into 4 separate columns. I was wondering if there was a way to allow me to click on the individual categories and control the data that is shown in the table visual like I have done in my other reports. See the images below to see what I am currently having issues with.

Report View (Clicking one of the categories on Pie Chart needs to show data based on selection in the other visuals)Table View (How the data is tied together. The nulls are just cells that are blank)

[amitchandak · Accepted solution]

@Matt_Mohawk , No. For that, you need unpivot these 4 columns

https://radacad.com/pivot-and-unpivot-with-power-bi

[Matt_Mohawk]

Thank you! I am trying that out right now.