Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamically url filter Power BI live dashboard tile from Power apps

Hi all

 

My requirement is to integrate Power BI tiles in Power Apps. Our project is Agile in nature so report keeps getting updated and published with each sprint. I am trying to integrate BI tile using dynamic url filter option. This works absolutely fine if the BI tile is pinned as a visual(snapshot). Considering Agile nature of our project, we are looking to dynamically integrate a tile which was pinned as 'LIVE PAGE'. I am unable to filter the tile with the url filtering option.

 

Any suggestions would be indeed helpful

 

  • ibarrau's avatar
    ibarrau
    6 years ago

    Yes sure. Relative dates are dates you can't know which are until you delimite a time line. For example "Yesterday". What is yesterday? it depends on the date we are. This is an example of those. A relative date is thinking on filtering "last N days/months...", "this day,/month..." or "next N days/months..."

    With that kind of filter your tile will always be this month, for example, and automatically will change it's data every month.

     

    Here you can check about them

    https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

     

    Regards,

4 Replies

  • Hi. I'm sorry but the tiles on the dashboard are only filtered once. After you pin the visualization you can't do anything to change this filter context. The best practise con dashboard pin is to filter relative dates in order to always have data up to date.

     

    Hope this helps,

    • Anonymous's avatar
      Anonymous
      Not applicable

      Thanks for the prompt reply. Can you assist me further on what exactly are 'relative dates'? Are these date columns in the dataset?

      • ibarrau's avatar
        ibarrau
        Icon for Super User rankSuper User

        Yes sure. Relative dates are dates you can't know which are until you delimite a time line. For example "Yesterday". What is yesterday? it depends on the date we are. This is an example of those. A relative date is thinking on filtering "last N days/months...", "this day,/month..." or "next N days/months..."

        With that kind of filter your tile will always be this month, for example, and automatically will change it's data every month.

         

        Here you can check about them

        https://docs.microsoft.com/en-us/power-bi/visuals/desktop-slicer-filter-date-range

         

        Regards,