Union tables with the same columns, and show them in a Pie Chart

[msuser48]

I have 3 different tables. The tables all have the same column, "col1", with different values in them.

I need to show the distribution of values in col1 for all 3 tables in a part chart.

So lets say there are..

- 25 rows in table 1's col1 with the value "No"

- 25 rows in table 2's col1 with the value "Maybe"

- 50 rows in table 3's col1 with the value "Yes"

I need a pie chart to show 3 slices: No, Maybe and Yes with their respective percentages (25%, 25%, 50% in this example case).

How to achieve this?

[v-yangliu-msft · Accepted solution]

Hi  @msuser48 ,

I created some data:

Here are the steps you can follow：

1. Create a table with Enter data.

2. Create measure.

Measure =
var _all=[Measure1]+ [Measure2] +[Measure3]
return
SWITCH(
    TRUE(),
    MAX('Table'[all])="table1",DIVIDE([Measure1],_all),
    MAX('Table'[all])="table2",DIVIDE([Measure2],_all),
    MAX('Table'[all])="table3",DIVIDE([Measure3],_all)
)

3. Result:

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[themistoklis]

@msuser48 

Create a new Table (Menu Bar --> Modelling --> New Table) and add the following formula:

NEW_Table = UNION(SUMMARIZE(Table1,'Table1'[col1], "ValueName", "No"),SUMMARIZE(Table2,'Table2'[col1], "ValueName", "Maybe"),SUMMARIZE(Table3,'Table3'[col1], "ValueName", "Yes"))

Then add a pie chart visual and put col1 field to Legend section and ValueName field to Values section of the visual

Finally go to 'Format' of the visual --> Detail Labels --> Label Contents (Data Value, percent of Total)

[parry2k]

@msuser48 easier to append tables in power query and then everything will be super easy.

✨ Follow us on LinkedIn and  to our YouTube channel

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make effort to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡ Visit us at https://perytus.com, your one-stop shop for Power BI-related projects/training/consultancy.