by Nate Moore | Dec 12, 2015 | Business Intelligence, Excel 2013
In Excel Video 488 I’ll show you a clever way to do Power View filtering using charts. Watch how I configure a chart to be used as a filter. It makes the filtering interactive and informative at the same time. You can select multiple chart elements to filter at a time...
by Nate Moore | Dec 7, 2015 | Business Intelligence, Excel 2013
I have 6 Power View filtering tips for you in Excel Video 487. The first tips are easy ways to minimize and close the filters area. You won’t necessarily make your visualization area bigger, but it does make it easier for your users to focus on the data they need to...
by Nate Moore | Nov 30, 2015 | Business Intelligence, Excel 2013
Power View filtering can add power and flexibility to your visualizations. There are a couple of ways to do power view filtering, so we’ll start with the basics in Excel Video 486. If you’ve filtered Tables or Pivot Tables in Excel, the filtering menus I’ll describe...
by Nate Moore | Nov 23, 2015 | Business Intelligence, Excel 2013
Sorting Power View visualizations is where we’ll start our review of Power View basics in Excel Video 485. Watch how easy it is to sort a table and a matrix by simply clicking on the column heading. Also note that a table can only be sorted by one column at a time,...
by Nate Moore | Nov 16, 2015 | Business Intelligence, Excel 2013
We’ll continue our discussion about getting started with Excel Power View in Excel Video 484. Watch for things that are easy to do in Power View but hard to do in a traditional Excel spreadsheet, and vice versa. We’ll chart our data a couple of different ways with...
by Nate Moore | Nov 9, 2015 | Business Intelligence, Excel 2013
Now that we have PowerPivot, Power View, Power Query and Power Map installed, set up and configured, we’re getting started with Power View in Excel Video 483. If you haven’t watched Excel Videos 472 to 482, this video will make a lot more sense once you have Excel...
