Skip to content
Category: Data Analytics
2019-07-23

Display your dates in Power BI – DimDate Series (3/3)

In today’s post, we’re going to end up with the DimDate series in Power BI. To begin, I will show you some of the visualizations that Power Bi offers by default as well as the personalized visualizations that we can find in the Marketplace.

1.Slicer

These are the types of Slicer that Power Bi Desktop offers for time measurements:

Slicer

As you can see, Year is a Slicer of type Dropdown and MonthNameLong is a Slicer of type List. On the other hand the Slicer Date is more interesting for the use of dates since it allows us to select a range of dates in a comfortable way. This selector is very useful for large ranges of dates. It also allows us to select a date from the calendar or write the date by hand as you can see below:

Slicer 2

2.Tables

Less and less used by Power BI consumers, but no less useful are the tables. Thanks to the tables we can observe the data in a detailed way.

3. Charts

The most used visualizations to show data in the range of dates are the graphs, these allow us to see at a glance in a non-detailed way the trend that follows the data. In the following image we can see some of the graphics that Power Bi offers us.

There is also a Graph that allows us to see the cumulative total of the data.

There are very interesting visualizations in the Marketplace like the following:

  • Ultimate Variance allows us to create graphics in a dynamic way for example in the following report we have selected from 2013 to 2016, so we have created 4 graphics.

  • ZoomCharts Advanced Timeseries is one of the most used visualizations. As you can see in the video with a simple click we can see the data in more detail each time.

  • CalendarVisual creates a calendar for each selected year in which we can observe the months and days with the saturation of color corresponding to the data.

To finish I would like to show you a custom display of the Marketplace that can be used for presentations. Thanks to Play Axis we can make the report go forward in time while we observe how the data is changing as you can see in the next video.

DimDate series:

  1. Creating DimDate in Power BI – DimDate Series (1/3)
  2. Working with TIME Functions – INTELLIGENCE – DimDate Series (2/3)
  3. Display your dates in Power BI – DimDate Series (3/3)

Complete este formulario para recibir la guía de Windows Server en Azure
*Obligatorio
Complete este formulario para recibir la guía de Windows Server en Azure
Gracias por rellenar el formulario [name]. ¡Aquí tienes tu eBook Gratis!
Complete este formulario para recibir 4 best practices to implement a comprehensive Zero Trust security approach
*Obligatorio
Complete este formulario para recibir 4 best practices to implement a comprehensive Zero Trust security approach
Gracias por rellenar el formulario [name]. ¡Aquí tienes tu eBook Gratis!
Complete este formulario para recibir Cloud Migration Essentials
*Obligatorio
Complete este formulario para recibir Cloud Migration Essentials
Gracias por rellenar el formulario [name]. ¡Aquí tienes tu eBook Gratis!
Complete este formulario para recibir Cloud security Advice for Nonprofit Leaders
*Obligatorio
Complete este formulario para recibir Cloud security Advice for Nonprofit Leaders
Gracias por rellenar el formulario [name]. ¡Aquí tienes tu eBook Gratis!
Complete este formulario para recibir Prevent data leaks with Microsoft 365 Business Premium
*Obligatorio
Complete este formulario para recibir Prevent data leaks with Microsoft 365 Business Premium
Gracias por rellenar el formulario [name]. ¡Aquí tienes tu eBook Gratis!
Complete this form to recieve the guide of Windows Server on Azure
*Required
Complete this form to recieve the guide of Windows Server on Azure
Thank you for filling out the form [name]. Here's your Free eBook!
Complete this form to recieve 4 best practices to implement a comprehensive Zero Trust security approach
*Required
Complete this form to recieve 4 best practices to implement a comprehensive Zero Trust security approach
Thank you for filling out the form [name]. Here's your Free eBook!
Complete this form to recieve Cloud Migration Essentials
*Required
Complete this form to recieve Cloud Migration Essentials
Thank you for filling out the form [name]. Here's your Free eBook!
Complete this form to recieve Cloud security Advice for Nonprofit Leaders
*Required
Complete este formulario para recibir Cloud security Advice for Nonprofit Leaders
Thank you for filling out the form [name]. Here's your Free eBook!
Complete this form to recieve Prevent data leaks with Microsoft 365 Business Premium
*Obligatorio
Complete this form to recieve Prevent data leaks with Microsoft 365 Business Premium
Thank you for filling out the form [name]. Here's your Free eBook!
Complete this form to recieve Cloud Migration Simplified Ebook.
*Obligatorio
Complete this form to recieve Prevent data leaks with Microsoft 365 Business Premium
Thank you for filling out the form [name]. Here's your Free eBook!