To cast a Power BI column from integer or decimal format to string texts use the following DAX code: Import dataset to Power BI I will first go ahead and import a sample office list from an Excel file managed by the Real Estate folks. Here is the data set that we have acquired into … Read more
Here’s a question from Kevin: I have a date time column in one of my Power BI data model table representing a timestamp. I would like to create a few additional columns to the table each of those will increment the first column by 08:30 hours, which is our default shift duration. Any ideas on … Read more
Melvin asks: I have a date column in my Power BI model. Can you explain how to create both month name and month number to the Power BI report i need to prepare for the next management meeting? Creating month columns in Power BI Define a date column In case you still don’t have a … Read more
Here’s a question from our reader, Martina: I have a table that contains date values. For reporting purposes, i would like to transform those dates into a custom text string which includes the date, month and year, which i would like to use when creating tables and charts in my report. Any ideas are appreciated … Read more
Here’s a question from Emilio: I loaded an Excel spreadsheet to my Power BI desktop app, and inserted a stacked chart visual. When looking at the x axis i see that the chart month axes (X) is sorted our in a wrong order – in my case alphabetically – which doesn’t make much sense. How … Read more
When working with RStudio you define a plot (either with R-base or ggplot2), but the chart doesn’t show up in the Plots tab in RStudio. Most probably, you can solve this issue by explicitly printing your plot: Display R plot if not showing up in RStudio Follow the steps below to print your R-base or … Read more
To fix the R no package called ggplot2 error in RStudio or Jupyter, proceed as following: Read on for a more detailed explanation on how to reproduce and fix the error. Reproducing the no package ggplot error In order to reproduce the error, proceed as following: Here is a screenshot take from RStudio on Windows … Read more
Today we will learn how to fix error messages that you could find in your R development tool such as RStudio, Jupyter and others, when trying to invoke the tidyverse library without it being installed. Understanding the error Error in library(tidyverse) : there is no package called ‘tidyverse’ Here’s a screenshot from the RStudio Console … Read more
In this tutorial we will learn how to append the contents of a Python list to a pandas DataFrame. We will start by creating a simple DataFrame and a Python list. You can use both to follow along with this example. Assign a Python list to a DataFrame From my experience, the easiest ways to … Read more
In today’s data visualization we will learn how to plot multiple time series on the same chart with pandas. Time series is basically information that is time dependent such as prices, inventory, sales etc’. In our example, we would like to plot revenue, expenses and ultimately profit for a fictitious business. We’ll use a line … Read more