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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Frequent Visitor

Power BI generate dynamic grid tables


I'm a newbie to PowerBI...

I'm wanting to generate a dynamic grid table where the first grid will display summary data from the slicer/parameter for Year/Month and the second grid must display summary data for Year-1/Month and the 3rd grid should display granular level data for both....I'm migrating this report from Tableau where I used parameters to get the list of dates from the database and based on the date selected from the dropdown I created calculated fields to calculate Year-1 and also create flags for Grid 1 and 2 to display respective Year/Month summary in the 2 grids and the 3rd grid would display combined granular level data for Grid 1 & Grid 2.
I've attached the pic below and left the 3rd grid blank for the granular data...


Thanks in advance for pointing me in the right direction! 



sample pbix file 

Frequent Visitor

@v-jialongy-msft Thank you for the response.

due to the sensitive nature of the data I'm sending a .csv file with summarized totals and current date and previous year date and category.  My aim is if I choose current date(Year/month) from dropdown it should automatically calculate Year-1 and display for same month previous year summarized data and display both in the 2 grids as shown in the image


pbix file attached sample

Community Support
Community Support

Hi @analyst101 


Can you provide detailed sample pbix file and the results you expect.So that I can help you better. Please remove any sensitive data in advance.



Best Regards,


Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors