cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
I_Like_Pi
Resolver II
Resolver II

Rotate a Textbox

I have a grid of 9 tables on a report page that summarrize 3 different attributes Vs 3 other attributes.

I would like to rotate a textbox 90 degrees to lable the Row of tables.

 

Seems like a basic function, am I missing something?

 

1 ACCEPTED SOLUTION

You cannot currently rotate a textbox in Power BI.

View solution in original post

23 REPLIES 23
shivaprakash09
Frequent Visitor

Hi Everyone,

 

There is a visual by MAQ software, added in the library called Text Enhancer which allows it.

 

Thanks.

 

danningkong80
New Member

This is 2021 now and appears still mission impossible. I am not a big fan of all of those 3rd party visuals as they commonly come with lack of support and robust testing therefore lots of bugs. For example, the text enhancer does not provide any font to choose and I can't even move the object on the canvas but only resizing as workaround.

bmarcowka
Frequent Visitor

Alternatively you can create an image text box and resize accoridingly.  I used Photohop but Microsoft Paint would work equally.  

Skotko
Advocate I
Advocate I

Another workaround is to make your text in word and use those functions to rotate to how you want it, take a screenshot, and then import it as an image.  Definitely laughable that this has to be a solution but this is power bi...

SteveArk
Helper I
Helper I

Another solution is to create the vertical text in a cell in Excel. This can be snipped and saved as a .jpg image. The image can then be inserted into the Power BI report.

JoshJames
Regular Visitor

Yeah @I_Like_Pi , there doesn't seem to be a great solution just yet. The best way I've found is creating an image in either InDesign or Illustrator with transparency grid turned on and the words I want at the angle I want (see below). Of course this requires having some version of Adobe Creative Cloud software (or something like it) AND going back and forth between applications, but it's the best I've found. I've added a super small, quick example below.

 

Vertical Text Applied in Power BI.png

Chels
Frequent Visitor

My work around is to use the y-axis of a graph to write and format the text vertically. I then take a snippet, save, and insert the image where I want it.

MAQ just released a plugin in the store called "Text Enhancer" that does all kinds of things, including text rotation. No workarounds needed. 

I used this and it worked pretty well, the only challenge being that you have to set up your text in a table - which is doable but a bit annoying. 

I am using text enhancer. I set the text direction is Vertical L to R. I uploaded my report on power Bi report server, but Internet explorer can't read the vertical direction. Please see the image below:
Scatter Y-axis IE.PNGScatter Y-axis.PNG

If you do the original workaround, is it the same issue?

That workaround is for some static value. Tha will work fine. Mine is a text enhancer whose value is dynamic based on user selection. For example if user selects GDP option from slicer than this vertical textbox will show GDp , if user selects Population then it will show population. 
There are many CSS or compatibility issues with IE(Internet Explorer). 

denveroed
Advocate I
Advocate I

Apparently this is STILL not an option??? Come on Microsoft. I'm having to replace an image with text because of a bug where the images don't load when published to the web. Now I can't duplicate the 90-degree text that was in the image with a simple text box? This is getting ridiculous.

mnewman943
Advocate I
Advocate I

I was shocked to see the answers in this thread regarding not being able to rotate the contents of a textbox. This is a BASIC element for Enterprise reporting.

 

I just figured out a workaround for this item that I am being forced to utilize because I refuse to take no for an answer when needing to distribute a report.

 

Hopefully this works for anyone reading this post:

  • I created a stacked bar chart
  • Go to the format for the newly created bar chart
  • Turn off all formatting options, EXCEPT for the "Y-Axis"
  • Expand the Y-Axis formatting options
  • Scroll down, or locate the "Axis title" property
  • Input your text
  • Set "Title text size" to an appropriate size.
  • Set "Font family" to an appropriate font

This is nothing more than a workaround, and I may have to deploy this using this workaround.

 

Cheers

I need txt box in 42 degree angle. not getting any option.

Such a nice Workaround - Thnx Smiley Happy

I just did what you described below as I replicated an excel combo chart in power bi, and had to edit the axis title. 

 

Do you realize the text size max out at 21? It did for me. When the text size goes to 22 there is an error indicator for "Y-axis". 

Nice one! Its high time Microsoft got this simple feature to a text box. wonder if we have a custom visual which does that yet?

Not all heroes wear capes. Nice job.

You cannot currently rotate a textbox in Power BI.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors