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.
I update a monthly snapshot file in power BI and archive the previous snapshot but I want to create a slicer so that users can select which month they want to view. The field name that I want to use for the slicer is different for each file "FY23 month name". Is there a way to create a slicer so that users can select "FY23 month name" from a single dropdown box despite being in different tables?
I have tried to connect the tables with a WBS code but the values are incorrect. Is their another solution?
@Anonymous , Create a common table using the month name/date from both the tables
Power BI- Power Query: When I asked you to create common tables: https://youtu.be/PqfGW6pl1Sw
Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-solution-8e3eccb41bda
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 |
---|---|
73 | |
71 | |
55 | |
38 | |
31 |
User | Count |
---|---|
71 | |
64 | |
60 | |
50 | |
45 |