Upcoming webinar on 'Inforiver Charts : The fastest way to deliver stories in Power BI', Aug 29th , Monday, 10.30 AM CST.    Register Now

Comments with Filter/Slicer Context Awareness in Power BI

by Inforiver | Oct 06, 2023 |
Comments with Filter/Slicer Context Awareness in Power BI

Comments with Filter/Slicer Context Awareness in Power BI

There are a couple of options available in the market today for implementing a commentary solution in Power BI. You may use PowerApps or go for a write-back solution with the help of a custom visual.

Unfortunately, both types of solutions have a major drawback. When users enter comments, the visual is not aware of the context (which can be set by a filter or a slicer in the report) unless the commentary data is retrieved back from the destination. This makes it an IT-dependent solution.

In this example below, changing the Year does not remove the commentary from the row, as the visual is blissfully unaware that the context has changed.

Comment with filter and slicer context 1

Even when you write back the data from the visual, the context (of Year and Class in the example above) goes missing. All of these limit the utility of the commentary implementations as they are seen mostly as static rather than dynamic and context-aware solutions.

Comments with filter / slicer context awareness

With the latest version 2.5 release of Inforiver Premium Matrix, you can implement context-aware commenting in your Power BI reports in a few clicks.

Inforiver has traditionally been supporting notes & comments at all levels - row, cell, column, and row/column header levels. The new filter-context awareness is now available for all these types of notes & comments. 

Observe how the comments change as you change the filters/slicers. Note that the ‘Notes’ field in this example below does not come from the data model – the values in this field have been entered directly in the visual.

Comments with filter slicer context power bi

With Inforiver, you need not use PowerApps, or utilize a backend server or write-back service for implementing context-aware comments.

Let us quickly see how to implement context-aware commenting in Power BI in three steps.

Implementing Filter/Slicer Context-Aware Comments in three steps

Step 1: Create a Filter Context Measure

There are two ways to do this. One is to write DAX measure yourself, and the second way is to let Inforiver automatically generate the DAX script for you to use.

a. Once you have built your report with Inforiver, Click on Home🡪Display.

Comment with filter and slicer context step 1a

b. It will reveal a property sheet. Click on Misc and scroll down to see the Filter/Slicer context option. Click on the information ‘i’ icon next to it on the right.

Comment with filter and slicer context step 1b

c. A Filter Context Measure popup will appear.

Comment with filter and slicer context step 1c

d. Enter the filter categories for which you want to capture the context. You need to provide both the category name and the corresponding table name from the data model.

In our case, we need to pass on the filter context for Year, Class & Country (refer gif animation above). Once you are done, click on Generate DAX button.

Comment with filter and slicer context step 1d

e. Inforiver will provide the script that you can copy (using the copy icon) 

Comment with filter and slicer context step 1e

f. Create the FILTERCONEXT measure using the script.

Comment with filter and slicer context step 1f

You can write your own script using the format provided above without going through the above steps. But when life gives you lemonade, why buy lemons? Inforiver makes it easier for you by automating that task.

Step 2: Assign the measure to Inforiver

Add the measure we created above to the ‘Others (OM)’ field. This will add a new column to the visual – but do not worry about it now.

Comment with filter and slicer context step 2

Step 3: Configure Inforiver

Go back to Display – Misc – Filter / Slicer Context from the property sheet and let Inforiver know where to pick up the context by selecting the measure that we created. Once you do it, the extra column seen on the table will disappear.

Comment with filter and slicer context step 3

* * * 

With the above steps, you have made Inforiver aware of the filter context at all times. All your notes & comments that you enter in Inforiver will be tied to this context. 

To continue - if you are using the Notes feature, click and add a separate notes column.

Comment with filter and slicer context 4

Double click on any cell and start typing your notes in. 

Congratulations!! You have just implemented context aware filtering in Power BI without PowerApps or a write-back centric solution.

Which edition of Inforiver I must use?

With the latest 2.5 release - both Inforiver Premium Matrix (PBI Certified) and Inforiver Enterprise Matrix support context-aware commentary. 

Inforiver Matrix is Power BI certified, and it does not require any server or backend service. It is the ONLY Power BI-certified solution in the market today to implement context-aware commentary. It uses the Notes feature (as explained above) and saves the commentary in the PBIX file.

Inforiver Enterprise not only captures context-aware commentary but also writes data + comments back to a destination of your choice. This is available through the Comments feature in Inforiver. This solution requires a back-end setup (needed for writeback). 

Share this on:

Get Inforiver brochure

Maximize your business potential with Inforiver's paginated reporting, data entry, planning & budgeting capabilities
Download now
Inforiver Logo
IBCS Certified
Power BI certified

About Inforiver!

Inforiver is the fastest way to do everything in Power BI. It enables citizen developer productivity and unleashes true self-service with our intuitive and interactive no-code data app suite for Microsoft Power BI. The product is developed by Lumel Technologies Inc, who are #1 Power BI Visuals AppSource Partner serving over 2,000+ customers worldwide with their xViz, Inforiver, and ValQ offerings.

5920 Windhaven Pkwy, #130
Plano TX 75093
BI Hub
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram