Images loading below. While you wait, can you answer this Excel related tip? Guess the answer then click SEE ANSWER to see how it can be done.

1. What is the shortcut to ONLY select the visible cells? Guess, then click 'See Answer' as it can be done.
2. How do you take all the formatting from chart (see 1 below) and PASTE it onto another chart (2)? Guess and then see how it can be done with 'See Answer'



PowerPivot Format Percentage for DAX Measure

PowerPivot Format Percentage for DAX Measure

One of the most useful features of the new DAX measures in PowerPivot is the ability to specify a set format for the measure so that every time you use it in a pivot table it automatically formats to your requirements, instead of the usual issue of having to format a pivot table every time you introduce a new value.

Related: Learn how to use PowerPivot

Most of the formatting is fairly obvious but the one that is slightly hidden is the PowerPivot format percentage option.

In traditional Excel the percentage formatting is its own option. However, in PowerPivot it has been included in the Number category.

To get to it you need to click on the Number catergory and then click on the drop down to find the percentage option as shown below