Wednesday, November 11, 2015

Power BI - Rotation Fix

Working with the still-new PowerBI desktop release, I ran into a small but frustrating issue. When adding a shape to a report, there is an option to rotate the object. By default, adding a "line" shape gives you a vertical bar. But what if you want a horizontal bar instead?
There is no option to type in a rotation value, so you can't directly enter 90 degrees. No problem, you say, you'll just move the slider!

Unfortunately, the slider stops at 87 and 93. There's no way to slide it to 90.
After some considerable cursing at the screen and sharing my frustration with others, my brilliant husband suggested I try the left and right arrows. Sure enough, that lets you step up and down by a single degree each time. AHA.
So if you're stuck trying to rotate something just right, use the arrow keys! This also works for increasing a fill or background transparency value, or anything else that uses a slider in PowerBI.

Microsoft confirmed that a fix is coming out in the next patch. No date available yet, but we will eventually be able to type in a value. Hurrah!