Skip to main content

Tips to save time when working with Power BI


Select same type of multiple visuals to format properties.

Imagine a Power Bi report which has 8 cards and you have 10 reports like that, in order to change the properties of all, how time consuming it is, but there is an easy way of doing it.

Power Bi allows to select multiple visuals by using “ctrl” and click. So you need to select the multiple same type of visuals in order to work with them simultaneously.





In the above image you can notice that I have selected multiple cards using “ctrl” and click and in the right side you can also notice that it allows certain options to be used in the “format” pane here we can add title, change back ground, add border and various artistic changes to the selected visuals.


Can you notice that I have done multiple common changes to the selected visuals and it is applied to all? This method is very helpful when you do common changes in multiple same type of visuals as it saves a lot of time. This method only works for same type of visuals, for an example if you select five cards and a slicer as a sixth one, then you wont be able to change the properties like I mentioned.

So in-order for this to work there are simply two conditions.

1. The visuals has to be the same type, if it is a card visual all the other selected visuals has to be card.

2. The changes has to be common like assigning the same color as back ground.


Copy Paste visuals within all the pages in the same report but not all the time.

Power Bi allows copy paste options within the same report. Unfortunately you cannot do this within multiple reports but if you have multiple pages within the same report it will help you to save a lot of time.

For an example if you have a logo which goes in all the pages you can simply copy paste it, also if you have a visual which goes on in multiple pages you can do the same, but it is not advisable to copy paste visual which will later be replaced by other fields, here there is a higher chance of visual malfunctioning, you won’t be able to identify the mistake since everything might be correct but still the visual wont work properly, most of the time it happens in the visuals you import from the store so be mined full when copy pasting since it might end up killing a lot of time, but for fixed field or static content like logo then copy pasting is a time saver.





Labels:

Comments

Post a Comment

Popular posts from this blog

Choosing color scheme for Power BI reports

Choosing beautiful colors for an attention seeking Power BI report is always challenging. Sometimes we may have an important message but it might go unseen if proper color scheme is not used, so it is important to create reports which are informational and visually appealing. In this blog our main objective is to get an idea about selecting appropriate color scheme and tools that can be beneficial to do this. What is a color scheme? As you all know not all colors look great together and you can tell stories by just having only two colors, have a look at the following image, there in the middle you can see a circle with same color and same dimension, only thing that changes is the back ground, but depending on the back ground the way you see those circles are totally different. Some small circles appear softer, some appear sharper, and some are brighter also you might notice movements or depth effect too. It is important to choose colors wisely to serve the purp...
Post a Comment
Read more

Ragged hierarchy in Power BI

Case- I have a data set which has to be visualized in a ragged hierarchy. What is ragged hierarchy A ragged hierarchy is a user defined hierarchy with an uneven number of levels.   You can see the above table which has 5 levels of hierarchy. In the first level we only have “World” as a category then moving forward to the next level we have two categories  namely “UK” and “USA” likewise the level of hierarchy is drilling down up to five levels with an uneven amount of categories. Creating a hierarchy in Power BI In the above image  you can notice that I have right clicked the “level 1” column which has to be the first level of our hierarchy, Once it is right clicked there you will notice “New hierarchy” as the second option then you will have to click that in order to create a new one. As you can notice in the above image once I have created a new hierarchy then a new column is created named “Level 1 Hierarchy” in that I have d...
3 comments
Read more

Identifying unused space consuming tables in SQL Server

  You might have an SQL Server database with lot of unnecessary tables. But you are unable to remove them because you don't know if it is still being used or not. Sometimes they have been created as a backup and not deleted so now it's there as a redundant and taking up your space. In order to identify such tables the below query comes in handy. You can check the Last Interaction date and the table size to determine what to do. As a best practice it is better to ha ve a last updated date as a column in tables to identify the current relevant tables. S ELECT   last_user_scan LastInteraction,   t.NAME AS TableName,   s.Name AS SchemaName,   p.rows AS RowsCount,   SUM(a.total_pages) * 8 AS TotalSpaceKB,   CAST(ROUND(((SUM(a.total_pages) * 8) / 1024.00), 2) AS numeric(36, 2)) AS TotalSpaceMB,   SUM(a.used_pages) * 8 AS UsedSpaceKB,   CAST(ROUND(((SUM(a.used_pages) * 8) / 1024.00), 2) AS numeric(36, 2)) AS UsedSpaceMB,   (SUM(a.total_pages) -...
Post a Comment
Read more