Forum Discussion

analyst101's avatar
analyst101
Frequent Visitor
2 years ago

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

sample pbix file 

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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

  • analyst101's avatar
    analyst101
    Frequent Visitor
    2 years ago

    Anonymous 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