again , perfectly demonstrated Power BI and Power automate functionality. Due to lack of time and other projects with higher priority on my list. I will definitely build myself this exact solution showed and explained so perfectly in your video series. Thank you very Much Miss Payton for your excellent content. Greetings from the Netherlands.
Hi! Very helpful video, I stumbled on it because I am searching a solution for my problem. I have a report with many pages and various maps. I would like to be able to select a hexbin on a map and then apply this selection to every page of the report. I am trying with drillthrough but it is not really what I need. Any idea on how I could achieve this? Thanks!
Thanks! I don’t think there’s a good way to do what you’re asking. The best solution I can think of would be to just put the content on a single page instead of multiple - you could add bookmark “tabs” or have it scroll down to show the rest instead of going into other pages. Otherwise synced slicers or the filter pane, but I can’t think of a way to do it via a map visual without drill.
@@bi-ome Thank a lot! I hoped there was a way maybe with Power Automate to get the selection of the user in an Excel and then maybe read this Excel back to filter the rest of the model. Put everything on one page could be the solution but I would need to add a sort of page navigation. I already tried with synced slicers but the users would need to select from a list of technical values (hexbins) and this is not really ideal. I tried putting the city as a slicer and this could be a possible solution. I will try with the one page idea, thanks!
@@carlottafabris225 You could, but you’d have to store it somewhere and direct query (Dataverse or SQL - you can’t direct query Excel) it I think - like get the latest entry in the table for the given user and use that in the slicer. 7/10 jank level haha. I’m not sure that would necessarily work either, they might need to refresh the page or something iirc…
It is so hard to find Power BI -> Power Automate content. There is so much potential! Your videos added to my knowledge, but it’s not exactly what I’m searching for. Where did you go to learn this stuff?
@@sholder9933 What are you looking for? Honestly I don’t know of a good learning source for this particular category of thing, that’s why I’m making these. Most of what I know about it I learned through trial and error. 😅
Hi Christine, this is a fantastic guide and resource! If I wanted to set up a similar Flow that did not require selection, but grabbed every row from the visual or visuals on a page, what would I select for the "Apply to each" output instead of "Power BI data item"? Would that just be Power BI data, or Body?
The looping would be the exact same - that's the behavior you get from not selecting anything in the table - it sends all the rows. Just make sure you have all the same fields in the button, and that any filters you're using apply to the whole page. It doesn't send specific visuals per se, we are just using the table to visualize what's going into it, and the cross-filtering on the visuals will filter what gets sent to the button if you select rows in the table.
@@bi-ome Awesome- I've just built this today, using a Flag as a filter for items processed by the automate button, and I wanted my table visual to filter out buckets that the automation flow needs to process. Right now I just have them on separate pages, but if I don't select the report table then its filters shouldn't get in the way of automation parsing the table data fields?
again , perfectly demonstrated Power BI and Power automate functionality. Due to lack of time and other projects with higher priority on my list. I will definitely build myself this exact solution showed and explained so perfectly in your video series. Thank you very Much Miss Payton for your excellent content. Greetings from the Netherlands.
Many thanks!
Hi! Very helpful video, I stumbled on it because I am searching a solution for my problem.
I have a report with many pages and various maps. I would like to be able to select a hexbin on a map and then apply this selection to every page of the report.
I am trying with drillthrough but it is not really what I need. Any idea on how I could achieve this?
Thanks!
Thanks! I don’t think there’s a good way to do what you’re asking. The best solution I can think of would be to just put the content on a single page instead of multiple - you could add bookmark “tabs” or have it scroll down to show the rest instead of going into other pages.
Otherwise synced slicers or the filter pane, but I can’t think of a way to do it via a map visual without drill.
@@bi-ome Thank a lot! I hoped there was a way maybe with Power Automate to get the selection of the user in an Excel and then maybe read this Excel back to filter the rest of the model. Put everything on one page could be the solution but I would need to add a sort of page navigation.
I already tried with synced slicers but the users would need to select from a list of technical values (hexbins) and this is not really ideal. I tried putting the city as a slicer and this could be a possible solution.
I will try with the one page idea, thanks!
@@carlottafabris225 You could, but you’d have to store it somewhere and direct query (Dataverse or SQL - you can’t direct query Excel) it I think - like get the latest entry in the table for the given user and use that in the slicer. 7/10 jank level haha. I’m not sure that would necessarily work either, they might need to refresh the page or something iirc…
It is so hard to find Power BI -> Power Automate content. There is so much potential!
Your videos added to my knowledge, but it’s not exactly what I’m searching for. Where did you go to learn this stuff?
@@sholder9933 What are you looking for?
Honestly I don’t know of a good learning source for this particular category of thing, that’s why I’m making these. Most of what I know about it I learned through trial and error. 😅
Hi Christine, this is a fantastic guide and resource! If I wanted to set up a similar Flow that did not require selection, but grabbed every row from the visual or visuals on a page, what would I select for the "Apply to each" output instead of "Power BI data item"? Would that just be Power BI data, or Body?
The looping would be the exact same - that's the behavior you get from not selecting anything in the table - it sends all the rows. Just make sure you have all the same fields in the button, and that any filters you're using apply to the whole page. It doesn't send specific visuals per se, we are just using the table to visualize what's going into it, and the cross-filtering on the visuals will filter what gets sent to the button if you select rows in the table.
@@bi-ome Awesome- I've just built this today, using a Flag as a filter for items processed by the automate button, and I wanted my table visual to filter out buckets that the automation flow needs to process. Right now I just have them on separate pages, but if I don't select the report table then its filters shouldn't get in the way of automation parsing the table data fields?
Thank you for the video, it’s very helpful.
Please may you assist on how we can get comments from Planner tasks
Comments aren't available currently, unfortunately