In this video, Patrick shows you how you can use a parameter, within a Power BI report, to dynamically change the data in a report. This uses M Functions within Power Query and a second source that has the key values to pull. Then using a gateway to enable refresh.
LET'S CONNECT!
Guy in a Cube
-- guyinacube.com
-- twitter.com/guyinacube
-- facebook.com/guyinacube
-- Snapchat - guyinacube
-- instagram.com/guyinacube/
***Gear***
Check out my Tools page - guyinacube.com/tools/
- Dynamic Power BI reports using Parameters ( Download)
- How to use Query Parameters for Dynamic Reports in POWER BI ( Download)
- How to Use Power BI Parameters to Create Dynamic Power BI Reports ( Download)
- Making data source parameters easy in Power BI Desktop ( Download)
- Power BI Parameters: Create Dynamic Reports Using Report Parameters ( Download)
- Using Parameters in Power BI ( Download)
- SWAP DATA SOURCES EASILY using Parameters in Power BI // Beginners Guide to Power BI in 2022 ( Download)
- Fields Parameter in Action I Practical Examples ( Download)
- Creating DYNAMIC USER CONTROLLED CHART using Parameters, Variables & more.. | Power BI ( Download)
- Power BI Field Parameters - Why & how to use them ( Download)
- Setup Dynamic Parameters to Filter data in your PowerBI Report | MiTutorials ( Download)
- NEW! Dynamic Slicers with Fields Parameters | ULTIMATE EXAMPLE in Power BI ( Download)
- Revisiting a Power BI solution with Dynamic M Parameters ( Download)
- Create Dynamic Reports || Manage Parameters in Power BI - How to write dynamic Power BI query ( Download)
- Can you use Power Query Dynamic M Parameters for multi-select ( Download)