Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
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/
Did I answer your question❓➡️ Please, mark my post as a solution ✔️ |
Also happily accepting Kudos 🙂 |
Feel free to connect with me on LinkedIn! |
#proudtobeasuperuser |
thank you very much. I suspected a need for pivot. I'll try it myself and then accept as a solution.
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.
I'm open to anything! wasnt sure how to model it better.
User | Count |
---|---|
94 | |
86 | |
78 | |
69 | |
63 |
User | Count |
---|---|
114 | |
99 | |
97 | |
65 | |
59 |