Ajan's BI Blog

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 f...

When we are doing any kind of solution our main focus is to satisfy our end users and to deliver a very user friendly solution in the end. We need to make their lives simple and it can be done by many means and one of them is allowing them to use voice commands to serve their purposes. In this blog first of all we will create a Cortana card in Power BI and allow the end user to view their interests by voice command in windows devices, then we will download Power BI application from app store and use Q&A voice command to get insights, currently there is no proper way of integrating Power BI and voice command in android devices but it will be there in near future. Important pre requisite You need to have Power BI pro account in order to share a Cortana card via an app, this can be created in Power BI services including end user for him or her to be able to integrate that to their Cortana and to activate it using voice command or by a simple search. You need to have d...

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...

Case – I have to create a dynamic card and it should display the product name and product price when I choose a specific product from slicer. We will see what is the card and slicer that I’m talking about when we move along. Why this has happened I have a product table which has to be presented in a user friendly manner. I wanted something like this to happen if user selects “Pen” from the slicer  “One pen is Rs.15” What I wanted to do next You can see my product table in the above image, now I want to add a column which displays something similar to “One pen is Rs.15” for each row corresponding to their Product Name and Product Price in this table and I have shown it below. As you can see above I have selected the column from examples option which is in the top left of Add column task bar of the query editor. If you don’t understand tap the below task bar and see it for yourself. Once I have placed the example and pressed enter the fol...

Case - I have two columns for country code and there are some mutual values and that is totally fine, but in some cases those columns have individual values for themselves without the other one having it, which had to be taken care when merging. Why this has happened When I was playing with data as usual I got a scenario where I had two country code columns from two different tables. How did I end up here These columns were extracted from two different tables where one is about offices and the other one is about other places. At one point I had to group by country code and see how many offices per each country and how many other places per each country and above tables are what I got.                      As you can see  there is “AE”  in both tables  but “TH” is only there in CountryCode/Other table likewise “TW” is only there in CountryCode/Office table. What I wanted to do next ...