How to filter by two criteria using column names from a table?

[bluetail]

I have a visual like this.

 

First, I want to be able to select by project ID, which works OK with a slicer.

Second, I also wish I could filter by Stage 0, 1...7, which are my table columns, and I want each of then to show in the title of my doughnut chart (e.g. by Stage 0, or by Stage 2). 

So I need help with filtering by Stage in addition to filtering by Project ID.

I have provided the link to my source excel table and  power bi file.

https://1drv.ms/u/s!AtS3DN4JGKISiBhzGCQ03ddKlNyn?e=wpYhPH

Thank you for any advice. I'm a beginner at Power BI.

[tackytechtom · Accepted solution]

Hi @bluetail ,

If it is this you are after, then I have a solution for you:

First, we need to do some unpivoting on your table. For this, go into Power Query (Home > Transform data), mark the Stage Columns and click unpivot Columns:

After, your table should look like this. 

I also renamed the column Attribute to Stage. After click on Close & Apply

Back in Power BI Desktop, add your slicers Project ID and Stage:

The donut chart has the following settings:

The table I changed to a matrix with the following rows, columns and values:

Let me know if this helps 🙂

/Tom
https://www.tackytech.blog/
https://www.instagram.com/tackytechtom/

[bluetail]

thank you very much. I suspected a need for pivot. I'll try it myself and then accept as a solution.

[vojtechsima]

Hi, @bluetail 
here you go but to be honest, this kinda strange design it would be way better if you could transform the Stages into rows and remodel it a bit.

[bluetail]

I'm open to anything! wasnt sure how to model it better.