Filter Power BI in Power Apps Using Multiple Columns

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. 

Additional Resources

Do It Form Me!
PowerApps Power BI Integration Dynamic Filtering

Share the knowledge!

Paul Rodrigues

Business Analyst with 20 years of IT experience creating practical solutions. I love to automate business processes through the use of technology while making the end users work easier. My current favorite tools are Power Apps, Power BI and Power Automate. #PowerAddict

You may also like...

Leave a Reply

Your email address will not be published. Required fields are marked *