Dynamicaly filter Power BI Tiles 📊📈 from Power Apps

Ғылым және технология

Hi PwrPeeps, today we will see how we can dynamically filter multiple #PowerBI Dashboard Tiles embedded in a #PowerApps #CanvasApp.
If you want to have some tiles from your #PowerBIDashboard and #embed them in different screens, it is not possible to filter them with a standard setting from Power Apps or Power BI. So we have to pass the filter parameters with the Dashboard Tile URL. To be able to pass the parameter dynamically we will create a combo box with the values that the parameter is expecting and concat the value we choose at the end of the URL.
If you want to learn more about Power BI, you are welcome to follow the channel and subscribe to the Power BI playlist here:
• Power Automate & Share...
and to the Power Apps playlist here:
• Power Apps
Feel Free to follow me on other social media platforms as well:
linktr.ee/EneaLicaj
Buy me a pizza 🍕- bmc.link/enealicaj

Пікірлер: 15

  • @Andyandrwew144
    @Andyandrwew144 Жыл бұрын

    This was a huge help. Other videos did not disclose the NewAPI setting of the Power BI tile.

  • @FabioSilva-kj3bm
    @FabioSilva-kj3bm Жыл бұрын

    Awesome, Worked perfectly. Thank you

  • @youssefchaneb7702
    @youssefchaneb77022 жыл бұрын

    I've struggled for hours to find out how to make this feature works, thank you so much !

  • @Enea

    @Enea

    2 жыл бұрын

    Happy to help Youssef, feel free to subscribe if you like :)

  • @mdhidayat5706
    @mdhidayat57062 жыл бұрын

    Thanks for the tip Enea. How do you filter with multiple comboboxes?

  • @gemmaparker82
    @gemmaparker82 Жыл бұрын

    Thank you, this is so helpful! I wonder if you know what to do when there are spaces in your data table and column names? It only works when there are no spaces, and I'm unsure how to manage the spaces

  • @Enea

    @Enea

    Жыл бұрын

    Thank you! In general you should avoid spaces when creating columns. I would have to see what it can be done but a quick fix would be to create the columns again without a space, instead use an underscore.

  • @ladyceberg
    @ladyceberg Жыл бұрын

    Hi thanks the video, it is very helpful! May I know how the tile URL looks like if I want to: 1. Add another combo box 2. Allow multiple selection

  • @adityaprakash9151
    @adityaprakash91515 ай бұрын

    What in case of multiple county

  • @Enea

    @Enea

    5 ай бұрын

    Good question, need to try it out!

  • @vegeta_231
    @vegeta_2317 ай бұрын

    Does the filter also work with power bi tiles from different data sets?

  • @Enea

    @Enea

    7 ай бұрын

    You are filtering the tiles in your dashboard directly. If the filter is possible in that dataset then yes, should not matter what dataset it is. But I haven’t tested it to be honest

  • @vegeta_231

    @vegeta_231

    7 ай бұрын

    @@Enea ok, thanks. I will test in the next days and then i can inform you

  • @ma.fernandasierraromero1614
    @ma.fernandasierraromero1614 Жыл бұрын

    Hi, do you know if I can filter a PBI on Power apps but using people from my organization, I try your code but looks like doesn't work with this kind of data

  • @Enea

    @Enea

    Жыл бұрын

    You can do that by using the Row Level Security in Power BI. This will only show the data the user is allowed to see.

Келесі