Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
liwenteng
Regular Visitor

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. 

CountryAmount

Singapore

 

50k
Vietnam100k
Thailand20k

 

End goal:

Sheet 2

CountryAmount
Singapore50k

 

Sheet 3

CountryAmount
Vietnam100k

 

Sheet 4

CountryAmount
Thailand20k

 

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 2
KeyurPatel14
Resolver IV
Resolver IV

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

Arul
Super User
Super User

@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...





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


LinkedIn


Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.