One of the biggest queries among developers was to determine the best method to include Power BI content into their software applications. Historically, it was typical to integrate the data files and content of this business intelligence tool manually into their personal or corporate application, but not anymore. There’s now a new method available that
Plotting data onto a map is a regular request when a company has data that is location based. In this post, we will look at some simple tips to plot data onto a map. The final map will show a bubble for each location, the size will depend upon the sales. The data is an Excel
For many companies, January is a month of reporting how well the previous year did or didn’t. In this post, I will walk you through a very simple method of adding conditional formatting to a column chart. Adding colours to indicate performance is a very quick method of giving a clear message. Adding Conditional Formatting
Every year we all hope for or hate the idea of snow over Christmas I thought we would look at snowfall data for the UK, apologies to all my international readers. The data is on a web page in small tables that need appending together ready to be put into a simple report in Power
It seems appropriate to build a Power BI calendar on New Year’s eve ready to plan 2019. So this post walks through the steps of building a calendar in Power BI desktop using DAX. The aim is to have a calendar that has columns for all the variations you quickly want from a date, for
Following on from yesterday’s post about Power BI dynamic titles this next post is to navigate to the filtered page using bookmarks and buttons to show a page filtered differently. The report used in this example is based on ice cream sales of different flavours. We will create a bookmark for each flavour and buttons
In this tutorial Power BI, I want to cover one of my favourite topics to teach dynamic titles. These titles are created using a measure that contains the values selected in a filter. Simple One Value Title This title will show which single value is selected in a filter. In this example, my report has
The retail industry has been transformed by e-commerce and m-commerce. Within these digital retail domains, it has become a regular business practice to collect vast amounts of customer data, including personal details, preferences and billing details. However, the challenge is not only to put together this heterogeneous data and keep track of it daily, but
Data visualizations are a hot commodity, and “Power” tools abound. To be sure, they are powerful. With some time, patients, and effort they can also be visually pretty appealing. But what happens when you want to create a very customized visualization, or you need to make it interactive like an application, or you need to
Data Visualization is the front end of every BI system, and getting it right is one of the most important tasks in a BI application. Good visualization will affect tremendously on decision making process, bad visualization leads to wrong decisions.
Page [tcb_pagination_current_page] of [tcb_pagination_total_pages]