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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Teneikan
New Member

3 tables, with same columns and rows (only the data differs), on differently named sheets

xa1.png

Hi i have some issues. The criteria I want to filter on is in the "row label", but it currently only filters the data from the month it is in. I do not have a year data at the moment, it looks like this, roughly, within the months (these are the sheets) everything has the same sorting, columns, rows, etc. I am wondering if there is a good solution if I have 3 tables, with same columns and rows (only the data differs), on differently named sheets in excel. Is there any ways to work with these columns so the visualisations will show which sheet they are coming from. To more clear, these are data from a monthly report, so I would like to see which month I am currently working with

1 ACCEPTED SOLUTION
Rayizer
Memorable Member
Memorable Member

@Teneikan  ideally if you have a year, you can just pull in from each sheet into a new column and then append them together, just untick the 'enable load' button on the other ones. But this can be easily done, by using the power query editor and use the append function and they'll stack under each other, so in power query you create a new column and name it as "year", just put the year in that column then use the 'append as new table' function

View solution in original post

1 REPLY 1
Rayizer
Memorable Member
Memorable Member

@Teneikan  ideally if you have a year, you can just pull in from each sheet into a new column and then append them together, just untick the 'enable load' button on the other ones. But this can be easily done, by using the power query editor and use the append function and they'll stack under each other, so in power query you create a new column and name it as "year", just put the year in that column then use the 'append as new table' function

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.