Blog - Page 3 of 8 - G Com Solutions Limited

Nesting SELECTEDVALUE in Power BI Dynamic Titles

31st December 2020
/ Power BI
/ By Grant Gamble

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.

Working in DirectQuery Mode

30th November 2020
/ Power BI
/ By Grant Gamble

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

Power BI DA-100: Edit and configure interactions between visuals

29th October 2020
/ Power BI
/ By Grant Gamble

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

Creating Mobile-Only Content in Power BI

30th September 2020
/ Power BI
/ By Grant Gamble

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

Power BI DAX “X” Functions

31st August 2020
/ Power BI
/ By Grant Gamble

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

The CALCULATE Function is a DAX TARDIS

4th July 2020
/ Power BI
/ By Grant Gamble

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

Power Query Trim and Clean Functions

15th June 2020
/ Power BI
/ By Grant Gamble

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

Power BI Formal and Informal Hierarchies

5th June 2020
/ Power BI
/ By Grant Gamble

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

Parameterizing SQL Server Connections

29th May 2020
/ Power BI
/ By Grant Gamble

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

G Com Solutions Running Virtual Power BI Training Courses

16th April 2020
/ Power BI
/ By G Com Solutions Training

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