Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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.
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
Solved! Go to Solution.
@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
@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
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
65 | |
63 | |
52 | |
37 | |
36 |
User | Count |
---|---|
82 | |
66 | |
61 | |
46 | |
45 |