Tips and Tricks in Power BI / Part III
A list with tips and tricks in Power BI which will make your life easier when creating dashboards
If you have not read the previous one yet, visit the link below.
Tips and Tricks in Power BI / Part II
For today, we will be focusing on using keyboard shortcuts which will make the process of dealing with dashboards much easier.
1.SHIFT + ? (question mark)
If you are one of those people who don’t remember the shortcuts that easy, you have to remember this one only. If you use this shortcut, this one will bring a window with all the shortcuts available in Power BI.
2. TAB or SHIFT + TAB
If you use TAB a lot in other Microsoft Office apps, then you might be familiar with it already. If you select anything in the dashboard, if you hit TAB, that will move you between charts. If you want to go back to the last one selected then you are supposed to hit SHIFT + TAB and that will re-select the previous one.
3. Use FORMAT Painter
Let’s say you have created the visual you want. If you have a couple more visuals that you would like to look exactly the same, then you can select the visual with the design, click Format Painter in the Clipboard section in Home Tab and then simply select the visual where you want to apply the same design and that will be applied.
4. Copy visuals from one project to another
Although you might already know this, this feature was not available before. You might be able to copy a visual from one dashboard to another one. Obviously the data won’t be transferred, just the design so if you want to use it to the other project you can change the source to the project you are working.
5. Add Search bar on Slicer
This feature it is not very counter-intuitive and I have seen people struggling to find it. Let’s say you have created a slicer where you have a thousands options to select and you want to offer people the option to search for it instead of scrolling through.
To give you an example, you might have all the countries listed in a Slicer and you would like to give people the option to type it to go faster to the country they want.
Then it will show as a search bar. One drawback of this feature is that it works only with Data Type as TEXT
That’s it for today. If you are in a mood to read more and you are curious to learn about tooltips, see the post below.
Cheers!
