Data Bear’s Monday Motivation Blog Post
I’m back with quick and easy Power BI tips to make your experience working with Power BI a pleasant experience and hopefully saving you some time.
Tip 1: Format Painter
In the process of creating reports and visually appealing data visualizations, there are many instances where you will have to create visuals that look similar in design.
This Power BI tips format painter allows you this with just the click of a button. Format painter is not a new function, it has existed all along, also in other Microsoft products like Word and Excel.
How to use Format Painter
Identify the visual that has the desired formatting. Make sure it is selected. Then click on Format Painter. Then go to the visual that needs to look the same, and click it. So the new visual will now have the same look and settings. Format painter does not only cater for colours and fonts but also Number formatting.
Tip 2: Stepped layout
The need for Pivot-like visuals has always been desired, and when users first start using Power BI, it does help to see similar features from the excel they were used to. With these Power BI tips, I will show you how a matrix visual allows for a similar look to the pivot.
To create this, simply choose the matrix visual. Add your data. And change the settings for the visual.
Tip 3: Enable load
Some data models are very complicated and there are many tables in the preparation stage of the report. Some of these tables do not get used in the front end of the report and can clutter the field view while designing the report. You can hide them on the front end of the report field view. But you can also completely disable the table not to be available in the front end.
For this Power BI tip, you’ll need to go into the query editor. Right-click on the table you wish to hide and untick Enable Load.
Have look at our training options here.