Conditional Formatting of Chart Labels On a SharePoint Hosted PowerPivot Workbook

[MD610]

Anybody have any ideas about how this can be accomplished?

I have a line chart with 2 data series doing a year over year comparison.

I also have added 2 addtional data series as a stacked area chart so that the region between the lines appears shaded...basically showing the delta.

Then I have added data labels for the shaded delta area that appears between the 2 lines. Sometimes this is a positive number, sometimes it is negative.

I have used Custom Number Formatting on the chart labels to make the negative values red and the positive values black. This works beautifully in the actual excel workbook before uploading it to SharePoint. Once uploaded to SharePoint, I only get all red or all black seemingly dependent on whatever the very first value is in my delta.

This is a bit disappointing since it works so well when not uploaded.

Any ideas, suggestions, or workaround to get the same effect on the delta labels that will work on SharePoint?

 

[miguel.escobar]

Number format:
#,##0.00;[Red]#,##0.00
positive;negative

You can actually define lots of other colors and parameters in the
Format Data Labels > Format Code

about the sharepoint stuff:
You should try it in Sharepoint 2013, a lot of the cool visualizations that you get from Excel 2010 doesn't work well in Sharepoint 2010.

Best!
Miguel

 

[MD610]

Thanks for the response. That is basically what I use in my Custom Number Formatting. Like I said, I get the results I want in Excel but it just doesn't work in SharePoint 2010 Excel Services.

As far as using SharePoint 2013, I would love to. However, we waited forever to get access to SharePoint 2010 and it was a major budget/time battle. SharePoint 2013 is a long way off for us. Upgrades like that generally do not occur quickly at large companies.

 

[miguel.escobar]

I'm going to add this to my to-do list when testing sharepoint 2013.
Btw, my company also has Sharepoint 2010 but it's still using SQL 2008 R2 and the upgrade will not happen anytime soon.

 

[MD610]

If you think of it, post back here and let me know about your results. Thanks!

 

[miguel.escobar]

Hey MD610! Could you send me a copy of your workbook to test it out on the SP2013 site that I have? so far, what I've tested gives sometimes the desired results and sometimes it doesn't. Hard to figure out why so I'm trying to use some other models as the sample file that I was using was just table with a numeric column from -20 to 20 but when I filtered all the negative values the data labels are invisible or hidden. My email is

 

[sunny25m]

We are one of the leading Sharepoint Development Company, have done many project successfully through out the year. I would definitely come with a solution to your problem

 

[miguel.escobar]

nevermind, tested about 10 different files with different scenarios, different amount of fields in rows and columns and they all work. The coloring is supported in SP2013

Thanks for the link, Sunny! but when it comes to Powerpivot hosting I prefer PowerPivot Hosting v2 with SQL 2012

 

[MD610]

Thanks Miguel. I appreciate you looking into this. Your findings will help with future planning although it will probably be a while until we are running SP2013 here. Information like this can always help build the case for why we need to do it sooner rather than later. Thanks again!