Monday, 15 June 2015

SharePoint 2013 - Show only Top 5 Feed in Newsfeed webpart

By Default SharePoint 2013 Newsfeed webpart shows 10 posts and there is no way to customize the number of posts out of the box.

So here is the cool trick to show only 4 posts instead of 10 using Jquery - Javascript.

<script type="text/javascript">
$(document).ready(function () {
   var limit=4;
   $("#ms-feedthreadsdiv").attr("numHiddenThreads", "6")
   $("#ms-feedthreadsdiv .ms-microfeed-thread").each(function(i){

By Setting numHideenThreads attribute value = 6 for the div help you avoid overwriting the "View Posts" link functionality to load rest of the posts.
If you don't set this attribute value, then on click of "View Posts" link, it will just load rest of the posts other than original 10 posts.


Sunday, 22 February 2015

Started with my Business Intelligence Training BLOG

I am proud to be part of BICG, where you get to work with the best people of the Industry who have same passion and that is technology.

I have been associated with BICG ever since I started freelancing and it has been a great journey. Working on latest technology in BI and SharePoint space give me new high.

To watch my latest training blogs visit here. 

Tuesday, 29 July 2014

SharePoint 2013 - Hide Edit and Show Title Row by Default

Quick tip:

I have created the custom list form. When the form is loaded, I wanted to hide the Edit and Page tool bar and show the Title row by default.

This easiest way to do that is to use below CSS using SharePoint designer after main content place holder.
<asp:Content ContentPlaceHolderId="PlaceHolderMain" runat="server">
<style type="text/css">
      #s4-ribbonrow{ display:none; }
      #s4-titlerow { display:block !important; }
This is the final output

Sunday, 12 May 2013

Targeting MCSD: SharePoint Applications

Since SharePoint 2013 developer certification is out. I have taken a small step towards achieve this goal.

Following are the requirements for MCSD: SharePoint Applications

Web Focused

SharePoint Focused

Next step is to clear 70-480.

Thursday, 4 April 2013

Ready to Publish my Power View report on SharePoint 2013

My SharePoint 2013 environment is ready with SQL 2012 and I am going to play around publishing my Power View report.

Stay tuned for more tips and tricks.

Excel 2013 Power Pivot Sorting - Tip

While creating a Power Pivot based report i.e. Pivot table or Pivot chart, using Month slicer is a very common requirement. There are number of blogs that shows how to sort the Month in natural order in Pivot table, you can also found some workarounds to sort Month in natural order for slicer also. One such tip is explained well in MSDN blog here.

But with Excel 2013, there is not need to have such workaround.

Assuming that you have Date table with following columns
  1. Year => 2010, 2011, 2012.......
  2. Month Name => Jan, Feb March.....
  3. MonthOfYear => 1, 2, 3..... 12
Now select the column Month Name, under sort and filter section of Home tab.
Now click on "Sort by Column.."

In this select the Column to be sorted and sorted by. Here, sort column is MonthName and By column is MonthOfYear. Click Ok.

Now you can add the Slicer of Month Name and it will sorted by natural order instead on alphabet. 

Using this functionality,any column can be sorted by any other column within the table.

Friday, 22 March 2013

Exploring Power View and Power Pivot with Excel 2013

The latest Buzz in Microsoft BI Space is Power View and Power Pivot. I had seen it initially when it was in CTP but now with Office 2013 is available, I have tried my hands with Power Pivot and creating my Power View reports using SQL data connection.

For the list of new features in Excel 2013 Power view see this link.

Though I am more interested in SQL 2012 with Power View for Multidimensional Model, it is still in CTP mode and can be downloaded from here.

I loved the Map Visualization so far and wants to explore the integration with SharePoint 2010 and SharePoint 2013.

Let's see how it goes.