G Com Solutions
About the instructor
All G Com Solutions trainers (both online and in person) are highly experienced IT professionals and qualified to deliver a wide range of Microsoft training courses.
They have a vast experience of delivering public and on-site IT training content at different skill levels, to groups of varying sizes and have all obtained the MCSA BI Reporting certification.
Power BI What-if Parameters by G Com Solutions is a short course which focuses on the use of disconnected parameter tables to add flexibility to your Power BI reports by allowing the user to customize the results produced by some of your key metrics.
We begin the course by discussing the use of Power BI’s built-in What-if parameter feature and analysing what it actually does behind the scenes.
One of the key limitations of Power BI’s built-in feature is that it can only be used with numeric parameters. So, the course then shows you how to extend this feature by creating and implementing your own custom parameter tables.
And we use the parameters feature as a launchpad to the creation of a sophisticated currency conversion dashboard which gives us a chance to practice other useful techniques, such as the inclusion of custom visuals in your reports, the use of DAX variables to make your formulas clearer and easier to maintain, and how to provide useful interactive feedback to your users by creating dynamic titles driven by complex DAX formulas.
So, if you’re looking to extend your knowledge of DAX and data modelling in Power BI, sign up for a for a free trial of Power BI What-if Parameters by G Com Solutions.
- 1. The solution we will be creating
- 2. Connecting to the data
- 3. Creating a date table
- 4. Creating a measures table
- 5. Creating a reference to a query
- 6. The Chiclet Slicer custom visual
- 7. The Timeline Slicer custom visual
- 8. Creating parameter slicers
- 9. Calculating the offset price
- 10. Ceating a dynamic title