Filtering PowerBI Tile with Gallery Selection

[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-withi...

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&" ' ")

[Farquad88 · Accepted solution]

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&"'")