Range Bar Chart - CustomAttributes.PointWidth ignored when using multiple series
Hi, Thank you in advance for your help. I have to make a horizontal range bar chart with the data coming from an SSAS CUBE. Unfortunately, the requirements entailed having each bar associated with a different measure each. I couldn't figure out how to write an MDX query that SSRS would like where I could have the SUM of the measures show up as different categories in the same series. For example, the measures would be Sum(dollars), sum(volume), sum(acres). They are not dimensions that I can group on. In order to create the range chart, I was forced to make each bar it's own series and each series have only one value. So, one series for dollars, one for volume, one for acres, etc. Then, they could be beside each other and "pretend" to be one series. However, the chart now has the bars touching each other (no margin between them) and If I set the point width of them all to be smaller, there is no difference to the way the chart looks. It is like the Point Width gives a relative size to the other seies, not an absolute size. What I am looking for is one or more of the following: 1) Is there a way to make an MDX query where I can make my measures look like dimensions? 2) Is there a way to use the category grouping expression or series grouping expression to combine all of my measures into one series? 3) Is the Point Width property supposed to work like this, or is it a bug that I should be logging with Microsoft? 4) Is there another property that I should be using on its own, or in conjunction with PointWidth that will make the bars a smaller width and look like they have space between them? Thank you so much for your response, MiaThanks, Mia
May 3rd, 2012 10:28am

Did you ever solve this problem? I'm having similar issues Thanks
Free Windows Admin Tool Kit Click here and download it now
May 15th, 2012 7:24am

Sorry Jimmy, I never was able to fix this. My charts will just have to look ugly. I did add it into Microsoft Connect. You can vote it up if you want: https://connect.microsoft.com/SQLServer/feedback/details/742160/range-bar-chart-customattributes-pointwidth-ignored-when-using-multiple-series Tell all of your friends :) And, if you do find a work around. please post it here so that I can find out too.Thanks, Mia
May 15th, 2012 9:37am

Not sure if it's what you're looking for but I found the PointWidth setting is relative and the PixelPointWidth setting is the absolute width in pixels, think you need to set PointWidth to 0 and PixelPointWidth to 20/30 or however wide you want it. Also for space between the bars you may need to set PointWidth to something < 1, e.g 0.8 for 80% of available space
Free Windows Admin Tool Kit Click here and download it now
May 15th, 2012 10:02am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics