Power BI Interview Questions
-
How can we pass slicer values across bookmarks?
-
What is bookmarks in power bi?
-
Before field parameters, how were dynamic dimensions, axes, or rows achieved in Power BI?
-
When does conditional formatting (Fx icon) become unavailable in Power BI?
-
What is Field Parameters in Power BI? How to create a dynamic Axis using a slicer?
-
What is Interactions in Power BI
-
What are the three format styles in Power BI conditional formatting?
-
What is conditional formatting in Power BI?
-
How to do a multi-column sort on a visual in Power BI?
-
Difference between Import, DirectQuery, and Live Connection Modes in Power BI
-
Why Date table is very important in Power BI?
-
I have a visual Brand on the category Axis and net measure on the value axis. I would like to add the city column on the tooltip, but there are multiple cities, how can I show all city values on the tooltip?
-
How can one change the theme in Power BI?
-
How can I add a constant or Average/Constant Line in my visual?
-
What is the Report Tooltip Page?
-
What is drill through in Power BI?
-
Can I drill through from a card visual?
-
How to use the button for Page Navigation?
-
Why, I am not able to add Map Visual on the Power BI desktop?
-
Why I am not able to see preview features?
-
What is RLS in Power BI?
-
What is OLS in Power BI?
-
What is Calculation Groups?
-
What are the usages of “Apply all slicers” and “Clear all Slicers”
-
What Power BI features could be improved?
-
What is incremental load in Power BI and what are the benefits of using it?
-
What is a Power BI on-premises data gateway?
-
I have moved my dataset file from the Development workspace to the Test workspace for the very first time. Assuming I have two years of data in the Development workspace, how much data will be there in the Test workspace for the first time before refresh?
-
What is the Deployment Pipeline in Power BI?
-
How can I transform a Power BI table with columns like Date/city/state, measure, and Value (measure value), where the measure column has values like sales, cost, and margin so that the measure values are in columns instead of rows?
-
Same Period Last Year Function in Power BI
-
What is DAX? (Data Analysis Expressions)
-
What is the difference between a Calculated Column and a measure?
-
What is the difference between sumx and sum in power bi?
-
What is the difference between the CALCULATE and CALCULATETABLE functions in DAX/Power BI?
-
the difference between Summarize and SummarizeColumns
-
What is the difference between all and allselected in power bi?
-
Difference between filtering data in CALCULATE with and without FILTER Expression
-
"I have a sales table with a measure called 'Gross.' The sales table is linked to the geography table via the City ID column. The geography table includes columns for City ID, City, and State. I have created the following measure
-
What is the difference between RELATED and RELATEDTABLE?
-
What is the difference between search and find?
-
If in the above visual, I add a column- city id, which also same granularity as a city, and from the same table, will I get the same ranks?
-
What is the difference between skip and dense in Rank?
-
What are the top 10 states by gross sales from the 'SalesData' table?
-
What are the common scenarios in which the Grand Total does not equal the sum of rows in both countable and summable measures?
-
What are some best practices related to Time Intelligence or Date Tables?
-
What do mean by MTD, QTD, and YTD in Power BI?
-
Which functions can I use to obtain MTD, QTD, and YTD results in Power BI?
-
Practical Challenge Questions 1 DAX
-
Practical Challenge 2 DAX
-
Practical Challenge 4 DAX
-
Practical Challenge 3 DAX
-
Practical Challenge 5 DAX
-
In what scenarios can I use the RELATED function?
-
What does FIRSTNONBLANKVALUE function do?
-
Give examples of Power BI/DAX functions that are very similar to SQL window functions.
-
What are the differences between DAX functions Rank and Rankx?
-
What is the difference between GENERATE and CROSSJOIN
-
What is the difference between the CALENDAR and CALENDARAUTO
-
What is the best way to find min values 5 columns or measures for a given table row or visual row?
-
How can we repeat the value of a measure or column?
-
How can we generate a series of odd numbers or even numbers?
-
Provide a measure that gives the Running/cumulative total using the date table
-
How to get Top/bottom performer?
-
How to add a unique sequence number field in Power BI visual?
-
How to append two tables in DAX
-
Give some examples of measures we can create using the Window Function.
-
How do I calculate the unique combinations of two columns in Power BI?
-
How do I sort a column of matrix visual in Power BI using a “Month Year” field in descending order?
-
Is there a way to set a date slicer to always show today’s date, or a month slicer to always show the current month in Power BI?
-
Provide a measure that gives the Running/cumulative total using the date table.
-
How to get Top/bottom performer?
-
How to add a unique sequence number field in Power BI visual?
-
Give some examples of measures we can create using the Window Function.
-
What is the difference between distinct and unique values in Power Query’s column distribution?
