Interview Questions and Answers

Power BI has various types of filters such as visual, page, report, drill-through, and slicer filters.

• Visual filters apply to a single visual or chart.

• Page filters apply to all visuals on a single page.

• Report filters apply to all visuals in a report.

• Drill-through filters allow users to navigate to more detailed data.

• Slicer filters allow users to filter data across multiple visuals.

SUM calculates the sum of a column or expression, while SUMX calculates the sum of an expression evaluated for each row in a table.

• SUM is used to calculate the sum of a column or expression in Power BI.

• SUMX is used to calculate the sum of an expression evaluated for each row in a table.

• SUM is typically used with columns, while SUMX is used with tables or filtered tables.

• SUMX can be used to perform more complex calculations by iterating over each row in a table.

Interaction mode in Power BI allows users to interact with visualizations and explore data in a more dynamic way.

• Interaction mode can be accessed by clicking on the 'Focus mode' button in the top right corner of a visualization.

• In interaction mode, users can hover over data points to see more information, filter data, and drill down into details.

• Users can also use the 'Selection pane' to show or hide specific visualizations or data points.

• Interaction mode is useful for presen...read more

Schema for n Power BI is the structure of the data model used to organize and connect data sources.

• Schema defines the relationships between tables, columns, and measures.

• It helps in creating a logical model of the data.

• Schema can be created using Power BI Desktop or Power BI Service.

• Example: A schema for sales data may include tables for customers, products, and sales transactions.

• Schema can also include calculated columns and hierarchies.

Power BI Report is a single report page, while Power BI App is a collection of multiple reports and dashboards.

• Power BI Report is a single page report with visualizations and data insights.

• Power BI App is a collection of multiple reports, dashboards, and datasets organized together.

• Power BI Report can be shared individually, while Power BI App is shared as a package of related content.

• Power BI App allows for more interactive and customized user experience compared to a single...read more