Home » Calendar By Tallan Power BI Custom Visual

Calendar By Tallan Power BI Custom Visual

This Calendar visual enables you to view the aggregation of data across a range of dates in a standard calendar layout.



This is microsoft certified custom visual, that you can get from App source library by searching for Calendar by Tallan.

To demonstrate this, lets take a sample dataset, as you can see below there are two tables named Calendar, and Global-Superstore.

Calendar table contains the date range while Global-Superstore contains a Sales Data.

Also there is a relationship exits between these table on Date and Order Date columns.

Note that, It is good to keep one separate calendar table that will have unique day month from Jan to Dec for all the year for which you have sales in your actual table, then create a relationship on date column with date column in actual table.

The reason is that, lets say if you use order date of Global-Superstore table for displaying a sales on calendar then there may be a possibility of not having an order for any specific month then in this case visual will not generate a calendar for that month.

If no data present for any specific month yet you want to display a blank calendar for that month then use a date field from a separate table that will have all the unique dates for whole year that is Calendar table in our case.

To generate a separate Calendar Table you can use following DAX.

Calendar = CALENDARAUTO()

Lets import a custom visual – Calendar by Tallan into your Power BI Desktop.

In visualizations pane, click on ellipsis ( three dots), then click on Get more visuals.

Now select All in category and search for calendar in search box. You will see a Calendar by Tallan in search result, click on Add button to import this visual into your Power BI Desktop.



[Also read other custom visuals , Word Cloud Visual , Small Multiple Line Chart]

Lets display the Total Sales by Order Dates.

Take a visual on report page, on visual date field take a Date column from Calendar table and in Values fields take a Sales column from Global-Superstore data table as shown below.

The Reason of taking date field from Calendar table is that it contains dates for whole year, that will generate calendar for each month.

Also will take a Year and Category slicers so that you can filter the Sales by Year and Category as well.

Once you done with these steps, you will see that visual look like as shown below.

As you can see the Total Sales based on Order Dates for year 2014 and category technology on calendar layout.

You can also see specific month Sales, Just click on month name as shown below.

As you can see, it displays the calendar only for that selected month.

Now to go back just click on arrow icon.

Formatting the visual

This visual does not provide much customizations, but the major one as follows.



In format pane, under calendar configurations you can choose a week start name for calendar.

Also can change Data colors as shown below.

 

Also Read..

Word Cloud Visual

Small Multiple Line Chart




SQL Basics TutorialSQL Advance TutorialSSRSInterview Q & A
SQL Create tableSQL Server Stored ProcedureCreate a New SSRS Project List Of SQL Server basics to Advance Level Interview Q & A
SQL ALTER TABLESQL Server MergeCreate a Shared Data Source in SSRSSQL Server Question & Answer Quiz
SQL DropSQL Server PivotCreate a SSRS Tabular Report / Detail Report
..... More.... More....More
Power BI TutorialAzure TutorialPython TutorialSQL Server Tips & Tricks
Download and Install Power BI DesktopCreate an Azure storage accountLearn Python & ML Step by stepEnable Dark theme in SQL Server Management studio
Connect Power BI to SQL ServerUpload files to Azure storage containerSQL Server Template Explorer
Create Report ToolTip Pages in Power BICreate Azure SQL Database ServerDisplaying line numbers in Query Editor Window
....More....More....More




Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.