Drill Through, Drillup/Drilldown And Tooltip

Power BI

Drill Through :

Steps :

→ Create a new sheet, and add a Pie chart

Ex : Count of the population by country

→ Now, create another sheet, and then add a simple table with

Country, state, and count of the population

→ Add country to the drill through the filter area of the table. Disable the Keep-all option for now.

→ Go back to the sheet with the pie chart and right-click any area, and then click on Drill through.

Drillup/Drilldown :

Steps:

→ Create a new sheet, and create a new hierarchy by left click on any column

→ Now, Select any columns and add them to the hierarchy and use hierarchy in visualizations

Ex : Create a hierarchy on the country column (Hierarchy Name: Country_hir)

Add State column to Country_hir

Add District column to Country_hir

Tooltip :

Steps:

Create a new page in the Power BI Dashboard

Goto Page Properties. Select Page size as Tooltip

Add a couple of visualizations. Ex: sales by cost

Goto View → Page View → select Actual Size

In the page properties(Page Information), enable the tooltip.

In the tooltip properties, drag and drop the Sales column.

Go back to the main dashboard, wherever you see the Sales column, the tooltip will be available.

Comments

Bookmarks and Buttons

Power BI Bookmarks and Buttons Select some columns into a table : Copy Visual and Paste, change it to Bar Chart by selecting any one of the columns and overlap both visuals: Goto View → Enable selection Pane and Bookmark Pane In selection Pane, we Can hide and Display visuals Bookmarks helpful to display state of visualizations : Now, Create a bookmark : → Add Buttons → Capture Visuvals by hiding required visuals Now, → Hide the Table and Off button create bookmark and capture bar chart Hide the bar chart and On Button, create bookmark and capture table Click on Bookmark1 and select the visible button and Enable action in the properties pane Type: Bookmark Bookmark: Bookmark2 Click on Bookmark2 and select the visible button and Enable action in the properties pane Type: Bookmark Bookmark: Bookmark1 Now, Ctrl+click on buttons to Capture Visuals

Difference Between Calculated Column And Measure

Power BI Difference Between Calculated Column And Measure Calculated Column / Measure : Calculated Column : A calculated column is an extension of a table using a DAX formula that is evaluated for each row. If you are accustomed to using Excel, you will remember that in Excel you often need to copy a formula for each cell of a new column, unless you format your range as a table. This results in each cell potentially having a different formula because of different cell references. When you write a calculated column formula, it is automatically applied to the whole table and evaluated individually for each row. Note: The Total summation value does not give correct values in calculated columns Example : Cal is Table name caluculated_Column = cal[cost]/cal[sales] caluculatedMeasure = SUM(cal[cost])/SUM(cal[sales]) Here Total sales/ Total Cost value gives 0.90 in measure 21/19 = 0.90 Where as in calculated column gives 5.00 wrong results sumx_Measure = SUM...

Power BI Architecture

Power BI Power BI Architecture : Power BI architecture has three phases. The first two phases use ETL (extract, transform, and load) process to handle the data. Data Integration: Data extract from different sources like databases, csv files, excel files, cloud, and different servers...etc Then the data is integrated into a standard format and stored at a common area that's called the staging area. Data Processing: Still, the integrated data is not ready for visualization because the data needs processing before it can be presented. This data is pre-processed. For example, the missing values or redundant values will be removed from the data sets. After that, the business rules will be applied to the data, and it transforms into presentable data. Then this data will be loaded into the data warehouse. Data presentation: once the data is processed. We can present data in visualizations and create reports These visual reports help business end-users to make business d...

Power BI

Search This Blog