Power Platform Community Forum Thread Details

Hi Everyone,

I'm building an app where I need to display a graph that show the percentage of each option.

Entity→ Table1 : Table2 (1:N)

Field→ Table2 entity>Column(Option set)

Option→ Option1/ Option2/Option3

I want to display a graph/pie chart once the user selected a specific item in table1 and the data that we want to display is on the other table which is Table2. We created a relationship where table1 is the parent and table2 is the child.

Example

Table1 Record (For example: Country1)

Percentage of Options (in Table2)

55%: Option1

21%: Option2

11%: Option3

7%: Option4

6%: Option5

1. We want to calculate the percentage of each option per record of table1.

2. We want to display a graph/pie chart.