Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowData Days is here! Join us now for 60+ days of learning, challenges, and connection. Learn more
Hi
I have plotted the following pie chart and was wondering how I would show the year which this data originates from on hovering over the pie chart (or any other way that can be seen).
The chart is plotted using the table below.
I have tried to drag the 'Year' column into 'Legend' which does reflect the information required but only allows one colour on the pie chart (see below) and I need both colours to remain how they are.
Thanks
Solved! Go to Solution.
@yasbui,
Remove year field from Legend, drag the Year field to visual level filters and set its value to 2018. There is an example for your reference.
Regards,
Lydia
@yasbui,
Remove year field from Legend, drag the Year field to visual level filters and set its value to 2018. There is an example for your reference.
Regards,
Lydia
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 23 | |
| 23 | |
| 21 | |
| 17 | |
| 13 |
| User | Count |
|---|---|
| 58 | |
| 51 | |
| 39 | |
| 29 | |
| 24 |