Quizalize logo
placeholder image to represent content

Conditionally highlight a bar

Quiz by Support - BusinessPromoted .com

Feel free to use or edit a copy

includes Teacher and Student dashboards

Measure skills
from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can
  • edit the questions
  • save a copy for later
  • start a class game
  • automatically assign follow-up activities based on students’ scores
  • assign as homework
  • share a link with colleagues
  • print as a bubble sheet

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
10 questions
Show answers
  • Q1
    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?
    Edit interactions of the slicer and set it to highlight.
    Filter the bar chart directly.
    Create a disconnected table.
    Change the slicer to a table.
    30s
  • Q2
    What are two mandatory columns included in the disconnected table?
    All the columns from the original table.
    Measures from the bar chart.
    The column that will be in your axis and the slicer.
    1. The column that will be in your axis and the slicer, 2. A column to sort the data for highlighting logic.
    30s
  • Q3
    What type of relationship should the disconnected table have with other tables in the report?
    Single relationship with the slicer table.
    No relationship (Disconnected table).
    Multiple relationships with all the tables used in the slicer.
    Bi-directional relationship with the slicer table.
    30s
  • Q4
    How do you create a measure to determine the months selected in the slicer in this case?
    Write a DAX measure that references the disconnected table and the slicer selection.
    There is no way to do this in Power BI.
    Use the slicer selection pane directly in conditional formatting.
    Write a DAX measure that references the slicer table directly.
    30s
  • Q5
    How do you format the bar chart to use the measure you created for conditional highlighting?
    Set the conditional formatting to color scale and use the measure you created.
    Set the conditional formatting to text color and use the measure you created.
    There is no way to use measures in conditional formatting in Power BI.
    You can only use pre-defined colors for conditional formatting in Power BI.
    30s
  • Q6
    What is the purpose of syncing slicers in this scenario?
    Slicers cannot be synced in Power BI.
    To filter all the elements on the page based on the selection in the slicer.
    To ensure selecting values from the hidden disconnected slicer highlights corresponding bars in the chart based on the measure.
    There is no need to sync slicers in Power BI.
    30s
  • Q7
    How do you hide the disconnected slicer after syncing it with the slicer that you will use on the report?
    Hiding the slicer will also remove the conditional formatting.
    There is no way to hide slicers in Power BI.
    Go to the View tab, select Slicers, and choose the disconnected slicer to hide.
    Disconnected slicers cannot be hidden.
    30s
  • Q8
    What does the author recommend doing after hiding the disconnected slicer?
    There is no need to take any further action after hiding the slicer.
    Hiding the slicer will break the conditional formatting.
    Instructing the users to use the synced slicer for highlighting and avoid using the hidden slicer for other filtering.
    Deploying the report to the end users without any instructions.
    30s
  • Q9
    What is a potential drawback of using disconnected tables for conditional highlighting?
    Conditional formatting limitations with disconnected tables.
    Disconnected tables cannot be used for highlighting.
    Performance issues with large datasets.
    Increased report complexity due to additional tables and measures.
    30s
  • Q10
    How can you mitigate the complexity of using disconnected tables?
    Use alternative highlighting techniques like tooltips or data labels.
    Disconnected tables are not recommended for highlighting.
    Create a separate report page specifically for managing the disconnected table and slicer.
    There is no way to reduce the complexity of disconnected tables.
    30s

Teachers give this quiz to your class