a click to split data into multiple worksheet based on the column i select

[liwenteng]

Hi All,

I am looking for a possible solution to split 1 table into multiple worksheet in just one click in Power BI.

Not sure if there is a way to do it in one click. 

Example: 

I have a table like below in Sheet1 in Power BI desktop.

I wan to split Singapore to Sheet 2, Vietnam to Sheet 3 and Thailand to sheet 4 with the same table layout as Sheet1. 

Country	Amount
Singapore	50k
Vietnam	100k
Thailand	20k

End goal:

Sheet 2

Country	Amount
Singapore	50k

Sheet 3

Country	Amount
Vietnam	100k

Sheet 4

Country	Amount
Thailand	20k

I know i can do it with macro if i connect the data in excel but is it possible to have a solution with one click or easy steps to split like the above? 

Appreciate your expertise advice. 🙂

Thanks.

[KeyurPatel14]

Hello @liwenteng ,
Can you please explain it in more detail or send any sample file for better clarification?
Thank you.

[Arul]

@liwenteng ,

You can duplicate or reference the table as much as you want and then filter out the Country in each table based on your requirement.
https://community.fabric.microsoft.com/t5/Desktop/Difference-between-Reference-and-Duplicate/m-p/102...