Browse by Tags

Power View 2013
27 December 12 02:00 AM | Ronen Chenn | with no comments

Those of you who looked for pie chart in PowerPivot and could not find it, can fild it now. To use it, you should install SharePoint 2010 SP1 and Sql Server 2012 SP1. The steps for appropriate installation can be found here : http://msdn.microsoft.com/en-us/library/hh231687

תגים:PowerPivot, BI, Power Pivot, BI Best Practice, Tabular, SolidBI.com, SolidBI, PowerView 2013

PowerPivot Change the file Max Size
20 November 11 04:03 PM | Ronen Chenn | with no comments

The default file size of PowerPivot file is 200M. you can change it in the trusted file location: For that, you need to login to the central administration site-> Excel Services Application->Edit Trusted File Location. change the the maximum file size to 2000 –> 2G.

תגים:ITPRO, DEV, TECH, sharepoint, Power Pivot

Replace the Sum(…) prefix in PowerPivot
20 November 11 03:04 PM | Ronen Chenn | with no comments

Problem : when playing with PowerPivot and adding  ∑Values you get the prefix Sum(…) before the value. Solution : 1.Click on the dropdown combo on the right hand. 2. Click on Edit Measure. 3.Copy the Formula in the “Measure will use this formula” … 4.Click on the New Measure icon in the Power Pivot Ribbon 5.paste the formula to the measure settings and change the measure name. 6. That’s it. now you have a new calculated member with your own caption ( Alias or what ever) Enjoy it!!!

תגים:ITPRO, DEV, EXCEL, TECH, PowerPivot, Power Pivot