Ever since we made a switch to Microsoft Office 2007 at work, this has been bothering me.”How to change one shape to another?”
This is very useful feature, especially when you are using powerpoint.
In excel 2003 you could do this using drawing toolbar.
But what about excel 2007 (or powerpoint, word 2007) ?
Well, they didn’t take out that feature in 2007, they just hid it under layers of ribbon menu structure in office 2007.
Here is how you can change one shape to another in Office 2007:
Just select the shape, go to Format tab in the ribbon, click on the wierd looking shape that suggests you can edit points of a shape, there you will “change shape” option. Use it to change shapes in microsoft office 2007.
Do you use change shape feature often ?
I use it all the time, especially when I am making presentations and need to switch between shapes until I find the right combination.
2 Responses to “Top 10 Power BI Interview Questions & Answers”
Hello...
In Power BI I have data that includes months by name only (e.g. May, April, December...)
I need to build charts etc. but i need the months to go chronologically... not alphabetically... I cannot seem to find the fix to this.... once again, my data does NOT have an actual date attached to it (like 02/01/2023)....only month names... can i use a helper table wher i id the month names as numbers 1 thru 12? and if so, how do i manage this to work for me ?
Thank you.
~Keith
You need to setup an extra table to map each month name to a running number. A simple 12 row table like
Jan 1
Feb 2
Mar 3
..
Dec 12
Then create a relationship between this month table and your month column
Now, go to "table view" in Power BI and set the sort by column to month number for the month name column on this new table.
Finally, use the new table's month name whenever you need to refer to the month name in the visuals.
They will be chronologically arranged.