Forum Discussion

Helper II

5 years ago

Solved

Resizing Indicator in Power Bi Report Builder

Hi All: How can I stop my indicators being resized because of the auto text wrap applied on the column to the left (Sub Category)?

Any help would be greatly appreciated. Thanks

sevenhills
5 years ago
Typical in SSRS report ...

Insert rectangle and then add the indicator ...

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/3a84706c-321a-4b49-b610-1312c2a0621b/resizing-issue-with-indicator?forum=sqlreportingservices

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/0f1575d0-af4d-4808-b58f-6486e47c732b/indicator-gauge-stretching-to-fit-row-height-need-to-set-it-at-a-fixed-height?forum=sqlreportingservices

Hope this helps!

5 Replies

sevenhills
Super User
5 years ago
Typical in SSRS report ...

Insert rectangle and then add the indicator ...

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/3a84706c-321a-4b49-b610-1312c2a0621b/resizing-issue-with-indicator?forum=sqlreportingservices

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/0f1575d0-af4d-4808-b58f-6486e47c732b/indicator-gauge-stretching-to-fit-row-height-need-to-set-it-at-a-fixed-height?forum=sqlreportingservices

Hope this helps!
- powerinM
  Helper II
  5 years ago
  Thank you. I will try the workaround. I think I heard about this solution previuosly. Just couldn't remember at the time when I posted my issue.
  Cheers
  - v-jingzhang
    Community Support
    5 years ago
    It looks interesting, does the workaround work in Power BI Report Builder?
    Thanks.
garythomannCoGC
Impactful Individual
1 year ago
Add links as sevenhills post ones are no longer working.
SSRS 2008 R2 - Keep Indicators From Stretching
SSRS indicator sizing
Set CanGrow property to false for the matrix/table cell.
And yes the first step for a new 'bare' matrix/table cell is to insert a rectangle object within the cell.
Then insert your Indicator/Guage object.

Further note to future self. The actual size of the graphic object can be controlled via the ScaleFactor property.
ScaleFactor value range is 0..1 ie 0 to 100% of size. Thus one can not make larger dynamically. All one can do is make the graphic object larger manually and scale down.