Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
dlogan
Helper I
Helper I

Formatting Chart Objects

Day 2 of learning Power BI: I am recreating something from Excel and would like to have objects look the same. The image below shows a side by side with Excel on the left. I can't find anywhere that lets me format objects in Power BI similar to the way that can be done in Excel. 

  • Vertical Text Box - Can this be centered veritically?
  • Charts
    • Can I remove "Count of Status" and "Divison"?
    • Instead of the label showing Percent, can it show Count?

I am falling in love with Power BI. Any help would be greatly appreciated.

 

Thanks, Dale

 

dlogan_0-1678805430588.png

 

1 ACCEPTED SOLUTION
AndrewPF
Helper V
Helper V

Carriage return is a new line character. 

Just press "Enter" before the start of your text to move the visible text downwards as many times as you need to get it into the centre of the box. 

View solution in original post

4 REPLIES 4
AndrewPF
Helper V
Helper V

Carriage return is a new line character. 

Just press "Enter" before the start of your text to move the visible text downwards as many times as you need to get it into the centre of the box. 

Now I see. "Carriage Return". Didn't think about it until now. I am guessing that term goes back to the type writer days. 🙂

 

AndrewPF
Helper V
Helper V

Just add carriage returns to the text and it will move it down to the centre of the box. 

You can remove the "Count of Status" and "Division" by switching the X-axis and Y-axis titles to "Off", e.g.: 

AndrewPF_0-1678808393970.png

 

Thanks for your help. I found everything except carriage returns for a text box. Where might I find that setting?

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.