Forum Discussion
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?
You could add a shape, remove Outline, remove fill, add text and rotate 🙂
28 Replies
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
Not all heroes wear capes. Nice job.
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?
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".
You could add a shape, remove Outline, remove fill, add text and rotate 🙂
Great workaround, but we cannot BOLD the text.
You have two fonts which allow for bold text: Arial black and Segoe UI Bold
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.
You cannot currently rotate a textbox in Power BI.
Really? How is it possible that an easy function does not exist in a sophisticated application. My comment goes to Microsoft! Let's see how long does it take to have this function...
Really? How is it possible that an easy function does not exist in a sophisticated application. My comment goes to Microsoft! Let's see how long does it take to have this function...
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 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:
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.
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.
Alternatively you can create an image text box and resize accoridingly. I used Photohop but Microsoft Paint would work equally.
