PricingCommunity

✨Filter Context

The xViz Performance Flow visual allows you to add descriptive notes to nodes, enhancing the storytelling around your data. These notes dynamically adjust based on the filter and slicer selections, providing contextually relevant insights.

Filter Context in xViz Performance Flow for Power BI

Example:

In January, Brandon’s low sales may be attributed to health issues and sick leave. A Data Analyst can add this note to Brandon's node. To analyze Brandon’s performance for the next coming month. The note is only displayed when January is selected in the Month slicer.

This is where the filter context will help. The filter context will ensure that notes are displayed only when the corresponding slicer selections are made, providing relevant and accurate insights based on the selected data.

Steps to configure Filter Context in the xViz Performance Flow visual:

  1. Create a Month Slicer in the report

Image 2: Month Slicer

  1. Next, navigate to the Performance Flow visual and click on Filter Context in the Analyze Pane located at the top of the menu pane

Image 3: Top Menu - Analyze Pane

  1. Click on “Generate DAX” to generate a DAX query

Image 4: Filter Context Settings

  1. We get the pop-up box to provide details of the columns used in the Slicers. The table name and column names.

Image 5: Filter Context Box to add Table Name

  1. Add the Table name and column name of the columns used in the Slicers of the report.

  2. Click the Generate DAX button, and a new DAX measure will be generated. You can also add multiple slicers by clicking "Add New"

Image 6: Click on Generate DAX

  1. We get a DAX query that will return the value/(s) selected in the report slicers.

  2. When a DAX measure is created, a copy button appears. Click it to copy the DAX measure.

Image 7: Click on the Copy Icon to copy the measure

  1. Create a new measure in the data model and paste the copied DAX query as its definition

Image 8: DAX measure

  1. Add the newly created measure data field of the xViz Performance Flow visual

Image 9: Filter Context option in Data Pane

  1. The visual will now have context about what values have been selected in the Slicers.

  2. Referring to the example we considered in the Introduction:

    • In the Month slicer, select January

    • Hover on the node on which you would like to add the note

    • Click the ellipsis icon on the top of the node

    • Select "Add note”

Image 10: Click on the Ellipse icon to add a note

  • Type the note on the person who had a low performance in January, note on the Salesperson – Brandon Harris had the lowest sales due to health issues.

Brandon's note will only appear when the Month slicer is set to January, as display in the GIF below

Image 11: Low Performance of the month

  • Now change the month to April and add the note for the highest sales performer – Mike Jones is the Highest Sales performer in all the regions in this month With the Filter Context, this note is only specific to April.

Image 12: Highest Performer in April

Result:

No notes will be displayed when different months are selected in the Slicer, other than January or April:

Image 13: No notes when February is selected in Slicer

Filter Context allows us to add notes based on specific value selections, ensuring that these notes are displayed only when the relevant selections are made. This ensures that the annotations remain context-specific and do not clutter the entire chart, providing a clearer and more focused analysis.

Previous✨User Context - RLS ExperienceNextFormatting Features

Last updated

Was this helpful?