Category Archives for Blog
Nesting SELECTEDVALUE in Power BI Dynamic Titles
In Power BI, you can create dynamic titles for any visuals, by creating DAX measures which track the current state of the fields displayed within the visual itself or other related slicers and visuals. These dynamic titles can be used to convey useful feedback to report consumers as they interact with your reports. The main […]
Continue reading
Working in DirectQuery Mode
In this post, we will contrast the importing of SQL Server data with working in DirectQuery Mode. When you use the DirectQuery option, data is not imported from SQL Server into the data model of your SQL Server report. Instead, when the report creator configures visuals in Power BI Desktop, the actual data source is […]
Continue reading
Power BI DA-100: Edit and configure interactions between visuals
Exam DA-100 | Edit and configure interactions between visuals In this series of blog posts, we will be examining some of the key features of Power BI Desktop, Power Query and the Power BI Service needed to pass exam DA-100: Analyzing Data with Microsoft Power BI. The series was originally mapped to the MCSA: BI […]
Continue reading
Creating Mobile-Only Content in Power BI
Mobile-optimized Reports Mobile reports are based on the regular web report which you will have already created, with the layout adapted and optimized for mobile. For example, adapting a four-column desktop layout into a single-column mobile one. Page-by-Page Layout Mobile reports must be designed on a page-by-page basis, with a separate design for each page, […]
Continue readingPower BI DAX “X” Functions
In this series of blog posts, we will be examining some of the key features of Power BI Desktop, Power Query and the Power BI Service needed to pass exam DA-100: Analyzing Data with Microsoft Power BI. The series was originally mapped to the MCSA: BI Reporting; however, the topics covered are also relevant to […]
Continue reading
The CALCULATE Function is a DAX TARDIS
In spite of its bland name, the CALCULATE function is the most important function in the DAX language and by far the most widely used in advanced DAX calculations. The power of the CALCULATE function stems from the fact that it allows you to change the context in which a DAX calculation takes place. One […]
Continue reading
Power Query Trim and Clean Functions
In this series of blog posts, we will be examining some of the key features of Power BI Desktop, Power Query and the Power BI Service needed to pass exam DA-100: Analyzing Data with Microsoft Power BI. The series was originally mapped to the MCSA: BI Reporting; however, the topics covered are also relevant to […]
Continue reading
Power BI Formal and Informal Hierarchies
In this series of blog posts, we will be examining some of the key features of Power BI Desktop, Power Query and the Power BI Service needed to pass exam DA-100: Analyzing Data with Microsoft Power BI. The series was originally mapped to the MCSA: BI Reporting; however, the topics covered are also relevant to […]
Continue reading
Parameterizing SQL Server Connections
Query Parameters allow you to make the content of a report dependent on one or more parameter values. If we parameterize a data source, then we can update all our queries using that data source simply by specifying a different parameter value. In this demonstration, we will parameterize the name of the SQL Server instance […]
Continue reading
G Com Solutions Running Virtual Power BI Training Courses
Given the official guidelines regarding social distancing and the restriction of all but essential travel, G Com Solutions are now converting all of their training courses into live, instructor-led Power BI virtual training courses. We will strive to ensure that our Power BI virtual courses provide all of the benefits of our classroom training sessions […]
Continue reading