In many Power BI datasets, you’ll notice a separate table containing measures. While this isn’t really necessary, it can be useful.
The downside is that as the number of measures grows, this table will be absolutely flooded with measures, which makes it hard to find the measure you need.
The usual solution for this problem is creating folders in the table... but at first sight, it looks like you can only create folders at the table level, not within the folders themselves. It is possible, though - if you know how.
As an HR, marketing or operational team member, you may have been confronted with situations where you need to set up individual Teams sessions for a series of colleagues.
Wouldn’t it be nice if you could just create and describe those sessions in an Excel table and use that table to create all sessions automatically in Teams at the push of a button?
Well… you can! Power Automate makes it easy to set up automations like this one.
Did you know? Sheet Views have been around for a while in the online version of Excel, but now they are also being added to the Excel desktop app.
We are increasingly working together on documents. This means that we more frequently open and edit documents at the same time. Sheet Views allow different users to use their personal filtering and sorting simultaneously. And yes, without affecting your colleagues.
In fact, we’re talking about specific ‘views’ here. In order to use them, the file in question must be stored on OneDrive or SharePoint.
Typing quickly - never mind touch-typing: it's not for everyone. Are there specific recurring words or phrases you need to use in written correspondence that you still haven't got the hang of? Recognising your own typing errors is bound to leave you frustrated. Good news! With AutoCorrect, you're in charge of your own Zen.
In Microsoft Office, every user can rely on an AutoCorrect file. This file is hidden somewhere deep in the C-drive, but can be accessed via the AutoCorrect options window.
We’ve been working from home for more than a year. Corona fatigue has become unavoidable. Do you have any idea how your team is coping? And what about you and your relationship with the team? To get everything on track in your job as a -people- manager, there is now MyAnalytics Insights from Microsoft 365: an ultra time-efficient solution that gives you clear insights into your relationships with team members. The MyAnalytics leadership page helps you monitor productivity, engagement and well-being. This enables you to quickly make the appropriate changes where necessary.
When giving a presentation, i.e. in Slide Show mode, many people tend to prepare the slides in a strict sequence. This can result in a presentation with many ‘intermediate slides’ which show the overview or agenda of the presentation.
But these intermediate overview slides are not actually necessary. You can easily switch between overview and a specific topic/slide in the presentation, without the need to manually create specific slides for this purpose.
In PowerPoint, you can use the Summary Zoom. This will result in an interactive slide with a corresponding zoom effect, which gives you an extremely easy way to move around your presentation. You're probably thinking 'that's a lot of work..'. No, not at all, it only takes a few clicks.
Woops! You’ve just noticed a glaring typo or sent wrong information in a Team or chat. Don’t panic – you can still correct the error.
In most organisations, reports in Power BI and on other BI platforms are created by specialists in consultation with the person who requested the report. While these reports meet most expectations, there are situations where users need or want to have their data presented in a different way. They might want to include an additional perspective that wasn’t in the original report, for example.
This need is often temporary and doesn’t require the existing report to be changed.
To accommodate this, Power BI now offers users the option to change the way visuals are displayed. This option is called ‘Personalize Visuals’. The precursor to this option, ‘Decomposition Tree’, was similar in some ways. In this blog post, I’ll shed some light on both options.