Forum Discussion
Data Relation in the same table
Hello,
i am trying to build two pie charts from the following table. Pie chart n1: % of opacity of each type (low-mid-high) and in pie chart n2 % of steel type by tn. I also need to be able to select one of the classifications of either pie chart (ex: Opacity MID) and see the Steel type pie chart in cases where the mid opacity is not 0.
this is the style of data i´ve got.
| Date | Heat Number | Opacity LOW | Opacity MID | Opacity High | Steel Type 1 | Steel Type 2 | Steel type 3 |
| 1/1/2024 | 501 | 1 | 2 | 0 | 2 | 2.1 | 0 |
| 1/1/2024 | 502 | 0 | 0 | 1 | 5 | 0 | 0.5 |
| 1/1/2024 | 503 | 1 | 1 | 2 | 0 | 5 | 0 |
Tomas1995 , a pie chart can be created on measures, no legend - like sum of these columns -Opacity LOW, Opacity MID, Opacity High
Same way on other three.
Pie visual: https://youtu.be/cyWVzAQF9YU?t=14629
Or you have unpivot the data and then create a pie on that dataUnpivot Data: https://youtu.be/cyWVzAQF9YU?t=57694
4 Replies
Tomas1995 , a pie chart can be created on measures, no legend - like sum of these columns -Opacity LOW, Opacity MID, Opacity High
Same way on other three.
Pie visual: https://youtu.be/cyWVzAQF9YU?t=14629
Or you have unpivot the data and then create a pie on that dataUnpivot Data: https://youtu.be/cyWVzAQF9YU?t=57694
Hi Tomas1995,
Thank you for reaching out to Microsoft Fabric Community.
Thank you amitchandak for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue? or let us know if you need any further assistance.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa
Hi @Tomas1995,
We wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.
Thanks and regards,
Anjan Kumar Chippa
Hi @Tomas1995,
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the super user resolved your issue.
If our super user response resolved your issue, please mark it as "Accept as solution" and click "Yes" if you found it helpful.Thanks and regards,
Anjan Kumar Chippa
