Missing Site Creation Setting in Project Server 2016

In this article, I will be fixing this issue

Missing Site Creation Settings in Project Server 2016


Scenario

In Project Server 2013, I was able to change the site creation setting from Central Administration by doing the following:

  • Open Central Administration > General Settings > Manage PWA.

Missing Site Creation Settings in Project Server 2016 Continue reading “Missing Site Creation Setting in Project Server 2016”

Advertisements

DataView is disabled in SharePoint Designer 2013

In this article, I will be fixing this issue

Adding Data View is grayed out in SharePoint Designer 2013.


Scenario

In SharePoint Designer 2013, I tried to add DataView in a web part page but unfortunately,  the Data View is grayed out as shown below:

DataView is grayed out in SharePoint Designer 2013


Cause Continue reading “DataView is disabled in SharePoint Designer 2013”

Show and Sort Slicer By Month or Quarter Name in Power BI

In this article, we will show

How to display and sort a Slicer control by Month or Quarter Name in Power BI? 

A slicer is a powerful alternative way to filter the dataset shown on the page.


Scenario

In PowerBI, when you try to use the slicer to filter by a date field, it shows the year of this date field by default.

Slicer By Year in Bower BI
Continue reading “Show and Sort Slicer By Month or Quarter Name in Power BI”

SharePoint Framework For SharePoint Server 2016

In this article, I will briefly answer the below SPFx related questions:

  • What’s SharePoint Framework (SPFx)?
  • Why SharePoint Framework (SPFx)?
  • Is SharePoint Framework (SPFx) available in SharePoint 2016 On-Prem?
  • What’s the Feature Pack?
  • What’s the difference between Feature Pack and Service Pack?
  • How to use SharePoint Framework in SharePoint 2016?

Continue reading “SharePoint Framework For SharePoint Server 2016”

The Supported and Unsupported Columns In SharePoint Calculated Column Formula

In this article, I will list

The Supported and Unsupported Fields in SharePoint Calculated Column Formula

The Supported and Unsupported Columns in SharePoint Calculated Column Formula Continue reading “The Supported and Unsupported Columns In SharePoint Calculated Column Formula”

Using Lookup Field in SharePoint Calculated Column Formula

In this article, I will explain

How to use Lookup Field in SharePoint Calculated Column Formula

Scenario

I have a list with a lookup field, I would like to use this lookup field in in SharePoint Calculated Column Formula but unfortunately, it’s not listed in the available formula column as shown below:Using Lookup Field in SharePoint Calculated Column Formula

Cause

It’s by design, The lookup column can’t be used in SharePoint Calculated Column Formula and SharePoint Column Validation.

Check The Supported and Unsupported Columns in SharePoint Calculated Column Formula.

Workarounds

Continue reading “Using Lookup Field in SharePoint Calculated Column Formula”

Convert Rows To Columns Using Dynamic Pivot In SQL Server

In this article, we will show How to convert rows to columns using Dynamic Pivot in SQL Server.

PIVOT rotates a table-valued expression by turning the unique values from one column in the expression into multiple columns in the output, and performs aggregations where they are required on any remaining column values that are wanted in the final output.

Note: The demo in this article based on database from the TechNet Gallery.


Scenario

We have decided to build a dynamic database by creating only three tables as shown below:

 Continue reading “Convert Rows To Columns Using Dynamic Pivot In SQL Server”