Intro to Power BI Filters
Filters remove all the data from the report, except the one that you would like to focus on and show on your report.
You can apply filters (page, visual, report, drill-through) in the Filter pane on the right. Applying any of the filters have direct effect on your report.
Power BI Filters in Valotalive Digital Signage
Valotalive Workplace Digital Signage is compliant with Microsoft with the Filters in Power BI. This means that you can apply the same filters in Valotalive Power BI Digital Signage app as you would in your report in Power BI Online or Desktop.
Power BI Filters on Digital Signage – An example
In this example there is a company wide sales report that needs to be displayed around the sales offices to engage and motivate your teams. You want to target the right view for the right audience. The video below shows the different views of our example report as seen on Digital Signage Displays:
Further information on the example can be found from the Valotalive blog post: How to Use Filters in Power BI on Digital Signage to Target Your Reports Better
Use Filters in Valotalive Power BI Digital Signage App
Prerequisites:
Valotalive app activated and authenticated
Please see MS Power BI report app - Activate & use
Filter views configured in Microsoft Power BI
First we need to check the Table and Column names as well as the Values for filtering in Power BI cloud:
A. Power BI Report's Table and Column names
In the example report we have stores in North Carolina, US and we’d like our Display to show the live report only for North Carolina.
Go to the Power BI report in Microsoft Power BI cloud to pick the values for filtering:
Hover your mouse over the field name (column) in your Power BI report and locate the name of your table, as shown in this image:
In this case the Table is Store and the Column is Territory.
B. Choose filtering values
In the example we wanted the Display to show the stores in North Carolina only. In this report the value itself would be NC (see image):
Next step is to login on to the Valotalive and search the Apps for configuration:
1. Modify the Power BI Report app settings
Go to Apps, choose the correct Valotalive Power BI report and go to the CONFIGURATION tab on the left.
Check that you have chosen the correct report. In the example the report data is from Retail Analysis SAMPLE PBIX Report from the drop-down menu (accessed through "pen")
2. Add filter in Valotalive and input your values
Search for SHOW ADVANCED button on bottom of the App's settings
Input the correct values in to the field Filter to use
To create this specific filter in this case:
Table is Store
Column is Territory
The value is NC
Note that all text, Filter values, are case sensitive
Once you are done and hit OK the filter should look as seen below.
You can apply multiple filters up to maximum amount of six.
It is easy to remove the filter clicking the red minus ( – ) icon on the right.
Save your settings from the top right corner
Complete the work by adding the app to a flow or directly to a display.