The default setting is to have the grouping icon below the grouped rows. But you can switch things and have the icon at the top of the grouped rows.
Monthly Archives: December 2019
Grouping Measures in Power BI
Its in the Model View
It is considered best practice to use Measures for all your values in Power BI reports and dashboards. One way to make it easier to find Measures is to group them together.
Free Webinar Recording – Excel Yourself 2019
Feedback score 93% based on 41 responses
In December 2019 I reviewed four of my articles from 2019 plus some new content.
The detailed pdf manual and example file can be downloaded using the button below. Content listed below the video.
CPD note – if you are claiming CPD for watching this recording you need to keep your own records. People who attend the live sessions receive an annual listing of attendances.
This year’s webinar includes
- a new logic function IFS
- how to do budget allocations across months using the MOD function
- how to do complex monthly budget allocations
- using helper cells to achieve advanced conditional formats
As always there will be other tips and tricks shared along the way.
Creating Groups for Power Queries in Excel
Put some order in your queries
Once you start to use Power Query you may find yourself with quite a few queries in the one file. To make it easier to control them you can use groups to keep similar queries together.
Excel Sort within a Sort
Colour by numbers
Did you know you can sort by colour in Excel? Did you know you can sort ascending or descending within that colour? I was asked a question in a recent webinar and in answering I found out that you can sort within a sort.
Applying a standard custom format in Excel
Styles to the rescue
One of the most common custom number formats used in Excel is the mmm-yy format. As an example this format displays all the dates in January 2019 as Jan-19. This format is used in most reports, budgets and financial models. There is quicker way to apply it than using the Format Cells dialog.