Question 1

What is the first thing to do if you want to conditionally highlight a bar in a chart based on the selected items in a slicer in Power BI?

Accepted Answer

Create a disconnected table.

Answer

Edit interactions of the slicer and set it to highlight.

Answer

Filter the bar chart directly.

Answer

Change the slicer to a table.

Question 2

What are two mandatory columns included in the disconnected table?

Accepted Answer

1. The column that will be in your axis and the slicer, 2. A column to sort the data for highlighting logic.

Answer

All the columns from the original table.

Answer

Measures from the bar chart.

Answer

The column that will be in your axis and the slicer.

Question 3

What type of relationship should the disconnected table have with other tables in the report?

Accepted Answer

No relationship (Disconnected table).

Answer

Single relationship with the slicer table.

Answer

Multiple relationships with all the tables used in the slicer.

Answer

Bi-directional relationship with the slicer table.

Question 4

How do you create a measure to determine the months selected in the slicer in this case?

Accepted Answer

Write a DAX measure that references the disconnected table and the slicer selection.

Answer

There is no way to do this in Power BI.

Answer

Use the slicer selection pane directly in conditional formatting.

Answer

Write a DAX measure that references the slicer table directly.

Question 5

How do you format the bar chart to use the measure you created for conditional highlighting?

Accepted Answer

Set the conditional formatting to color scale and use the measure you created.

Answer

Set the conditional formatting to text color and use the measure you created.

Answer

There is no way to use measures in conditional formatting in Power BI.

Answer

You can only use pre-defined colors for conditional formatting in Power BI.

Question 6

What is the purpose of syncing slicers in this scenario?

Accepted Answer

To ensure selecting values from the hidden disconnected slicer highlights corresponding bars in the chart based on the measure.

Answer

Slicers cannot be synced in Power BI.

Answer

To filter all the elements on the page based on the selection in the slicer.

Answer

There is no need to sync slicers in Power BI.

Question 7

How do you hide the disconnected slicer after syncing it with the slicer that you will use on the report?

Accepted Answer

Go to the View tab, select Slicers, and choose the disconnected slicer to hide.

Answer

Hiding the slicer will also remove the conditional formatting.

Answer

There is no way to hide slicers in Power BI.

Answer

Disconnected slicers cannot be hidden.

Question 8

What does the author recommend doing after hiding the disconnected slicer?

Accepted Answer

Instructing the users to use the synced slicer for highlighting and avoid using the hidden slicer for other filtering.

Answer

There is no need to take any further action after hiding the slicer.

Answer

Hiding the slicer will break the conditional formatting.

Answer

Deploying the report to the end users without any instructions.

Question 9

What is a potential drawback of using disconnected tables for conditional highlighting?

Accepted Answer

Increased report complexity due to additional tables and measures.

Answer

Conditional formatting limitations with disconnected tables.

Answer

Disconnected tables cannot be used for highlighting.

Answer

Performance issues with large datasets.

Question 10

How can you mitigate the complexity of using disconnected tables?

Accepted Answer

Create a separate report page specifically for managing the disconnected table and slicer.

Answer

Use alternative highlighting techniques like tooltips or data labels.

Answer

Disconnected tables are not recommended for highlighting.

Answer

There is no way to reduce the complexity of disconnected tables.

Related quizzes

Related quizzes