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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
analyst101
Frequent Visitor

Power BI generate dynamic grid tables

Hello,

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! 

Raj

analyst101_1-1709512651000.png

sample pbix file 

2 REPLIES 2
analyst101
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

v-jialongy-msft
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,

Jayleny

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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