Filter Power BI in Power Apps Using Multiple Columns

by Paul Rodrigues · Published November 15, 2019 · Updated November 30, 2019

Embedding a Power BI tile in Power Apps is an easy way to provide your users valuable data without having to jump through hoops creating them directly in Power Apps. There are some out of the box limitations in which you can only filter text columns and you can only filter on one column. In this post I will show you how to overcome these two limitations when you filter Power BI in Power Apps using multiple columns. Continue reading and you too will become an Office Power User!

How-to-filter-Power-BI--in-Power-Apps-Using-Multiple-Columns

Building The Data Model In Power BI

Let’s start in Power BI with some data. I am using a sample table called “FinancialSampleDemo”. To make the multiple columns work we will concatenate the country and month number columns into a single column. This will be the actual column we will use to filter in Power Apps.

Create a New Column.
- Name: CountryMonthCoef
- CountryMonthCoef = FinancialSampleDemo[Country]&FinancialSampleDemo[Month Number]
Publish to Power BI
Pin Visual to Dashboard

Inserting Power BI Tile in Power Apps

In Power Apps from the insert menu under charts insert a Power BI tile. We will concatenate the two drop downs for country and month number. It’s import to note that you must concatenate both the columns in Power BI and Power Apps in the same order!

Power BI Tile
- TileUrl: Append below to the end of the text string before the closing quotes. You have to specify the table/column.
  &$filter=FinancialSampleDemo/CountryMonthCoef eq ‘” &DrpDownCountry.Selected.Country &DrpDownMonthNumber.Selected.Value &”‘”
Drop Down
- Name: DrpDownMonthNumber
- Items: [1,2,3,4,5,6,7,8,9,10,11,12]
Drop Down
- Name: DrpDownCountry
- Items:
  GroupBy(
  FinancialSampleDemo,
  “Country”,
  “CountryText”
  )

Now you know how to filter Power BI in Power Apps using multiple columns! Please leave your feedback. I hope this article has been helpful for you so bookmark this blog as new articles are posted regularly.