Forum Discussion
a click to split data into multiple worksheet based on the column i select
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.
2 Replies
- ArulSuper User
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/102630 - KeyurPatel14Responsive Resident
Hello liwenteng ,
Can you please explain it in more detail or send any sample file for better clarification?
Thank you.