Answered

Filtering PowerBI Tile with Gallery Selection

(0) Share

Report

Posted on by Farquad88

I am attempting to have my powerbi tile inside the powerapp filter based on selection in a gallery.

I have followed some training pages here, which applies a filter to the tile: https://sterlingsdotlife.wordpress.com/2019/03/04/controlling-the-power-bi-filter-context-from-within-powerapps/

This works if you assign an individual filter option to the button, however I have 50+ options in a gallery that I would like to filter the tile by once selected.

I have my powerbi titleURL set as "https://xxxxx"&newvar

Within the onselect of the gallery I have: Set(newvar, "&$filter=data_table/Project eq"&" ' "&Gallery.selected&" ' ")

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

Farquad88 61 on at

Like
a
(2)

Report
Copy link

Link copied!

I have solved this on my own. I changed the formula in onselect of the gallery to Set(newvar,"&$filter=data_table/Project eq '"&Gallery.Selected.Project&"'")
disback 3 on at

Like
a
(0)

Report
Copy link

Link copied!

Farquad88, you are the hero we needed. Thanks for posting the actual answer after finding it.
Lino 123 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello, i have got an issue and where unable to do this. Could anyone be so kind as to assist me in this and tell me whats wrong?:
I want to filter per usersemail that is stored in a variable on start.
Tables name is: GBIT Intake Form List
Columns name is: Analyst_Email

"https://app.powerbi.com/embed?dashboardId=dashboardID &$filter= GBIT Intake Form List - Transformations/Analyst_Email eq " & glbUserMail