 Hey guys, welcome to SSUNITEX social decide and today we are going to see one more real-time interview question and answer so this question was asked in the PwC so recently one of my friend has attended interview in the PwC so this question was asked over there. So in the previous video of this video series we have already discussed one of the interview question that was asked in the PwC on the same interview. So I will provide the link of that video in the description of this video as well or you can go into YouTube and you can search for PwC Power BI interview questions and answers with my YouTube channel name that is SSUNITEX. You will see this so under this we have already discussed about this question so you can watch this video as well. So let's start with today's video. So here this question is for example we are having the data set let me quickly show the data set first. So this data set is containing the sales order ID, sales order date, customer ID, quantity, value, country and city. So as per the requirement we are having the aggregated data in this metric table. So when we are going to hover the mouse on the quantity or value field then another report should be opened and that report will be having the aggregated data as per the cities. So as we are in the India row so we can see the cities like Noida, Lucknow and Unnau. If we will go into the UK country then we will see Manchester and London. If we will go into the US then we will see all the cities which is Chicago, Houston, Boston, Newark and Austin. If we will go into all that is the total then we will see all the cities along with all the countries. So how we can create the report by which this new report will be opening by hovering the mouse. So this property is something we have already seen that is the tooltip. So this is calling like custom tooltip. So let me quickly go into another Power BI and here let me try to design the report. So first we need to add a new page on the existing one and let me call this page as tooltip and after that here we can use the column chart. So we need to select the column chart here and after that in the axis we can select the cities. So let me quickly drag and drop the cities into the axis and after that we can see the value. So value should go into the values field and this should be the sum of the values so that we can see. And we can also do the formatting whatever we want to do like here we want to enable the data level then we can enable. And after that we can change the color so this will be like dark black. Here we can see the display unit we can set like the thousands. So such type of things we can do here whatever we want to do in the formatting. So after that we can click outside this visual like on the page level and on the page level we will go into the format. So we will see the page information property under this. So under the page information we can see the tooltip. So let me try to on this tooltip. So this report page will be going to treat as a tooltip. So you need to remember like on the page level property of the report by which we want to make the tooltip as tooltip on here. Now we can hide this from here. So this will not be available once you will publish into the Power BI service. Let me go into the page one and under the page one we need to select the visual by which we want to get the popup. Then we can go into the format and under the format here we can see on the bottom side the tooltip option. So let me on this tooltip and after that we can see here the type. So the type is default and report page. So as we have created the report page as a tooltip so we can select that type and after that here we can see the page. So page which is indicating either auto none or the tooltip. So we have created the page which is tooltip so we can select that one and after that everything is okay. We can change the text size everything whatever you want to change. So I am not going to do anything. Now let me quickly go into the visualization and trying to check whether the popup is opening or not. So here as we can see we are able to open the popup. So for the India it is going Noida, Lucknow and Hunnau. Similarly for UK and US and once we will go into the total then we can see all the cities. So you need to remember two properties. First we need to create a report page and under the report page we can see the page level property where we need to enable the tooltip. Second on the page level we need to select the type as a report of that visual and after that we need to select that report page that we have created. So this was the question asked in the PwC. So thank you so much for watching this video. See you in the next video with new scenario.