Grouped Summary

Hey Everyone!

New to using Powerbi and the forum!

Can you please help to understand how to structure my table with hierarchy levels, as illustrated in the picture provided.

Cheers Adam

@adam,

Welcome to the forum!

Take a look at this course - comprehensively covers financial reporting including the data model setup, template development, DAX calculations, etc. Should be a great place to start for your project.

For a general roadmap on getting up to speed on Power BI, I recommend taking a look at this thread:

  • Brian

Adam,

Is this picture from Excel or Power BI? Power BI does not have the same functionality as Excel, but something like this should be doable. It also helps when posting questions in the forum if you post a sample PBIX file.

Thanks
Enterprise%20DNA%20Expert%20-%20Small

This snap shot was taken from constructionbi.com

So I’m assumming it was created with Powerbi.

If you have any other guidance that would be appreciated.

Adam

Adam,

The picture shown was using the Matrix visual. One tip is in the format painter section make sure that Stepped layout is turned off. Sam has shown this in some of his material as well, mainly when he went over how to setup financials. Best tip I can give you is to get something started on your end, and when you run into an issue post the sample PBIX file in the forum so that we can assist.

image

Thanks
Enterprise%20DNA%20Expert%20-%20Small

saw this in the november update. Havent looked at it yet, but looks like it be beneficial


2 Likes

Thanks Nick :grinning:

Interesting. Looks to have some ok functionality. Video they produced is hopeless though. Can hardly see what they are showing.