Forum Discussion
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
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
- ibarrau
Super User
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,
- AnonymousNot 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
Super 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,