Filter Context
Last updated
Last updated
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.
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.
Create a Month Slicer in the report
Next, navigate to the Performance Flow visual and click on Filter Context in the Analyze Pane located at the top of the menu pane
Click on “Generate DAX” to generate a DAX query
We get the pop-up box to provide details of the columns used in the Slicers. The table name and column names.
Add the Table name and column name of the columns used in the Slicers of the report.
Click the Generate DAX button, and a new DAX measure will be generated. You can also add multiple slicers by clicking "Add New"
We get a DAX query that will return the value/(s) selected in the report slicers.
When a DAX measure is created, a copy button appears. Click it to copy the DAX measure.
Create a new measure in the data model and paste the copied DAX query as its definition
Add the newly created measure data field of the xViz Performance Flow visual
The visual will now have context about what values have been selected in the Slicers.
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”
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
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.
Result:
No notes will be displayed when different months are selected in the Slicer, other than January or April:
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.