Learn Dashboards, Excel, Power BI, Power Query, Power Pivot
Excel templates can save you time designing, setting up and standardising forms and reports. There are hundreds of free templates covering many types of documents and themes available for all Excel users. Excel templates work in the Excel desktop app and Excel Online. Watch the Video Free Excel Templates You’ll find free Excel templates via …
In most cases you can easily remove Excel password protection if you’ve forgotten the password. However, the likelihood of your success depends on which password protection method was used, as some of the four options below are more robust than others. Excel password protection is available for: Sheets Workbooks File Open File Edit Each method …
New to Windows is the ability to import data from a picture to Excel*. No more typing data manually into spreadsheets. It works with image files or screen captures on your clipboard. It's available on the Data tab of the Ribbon > From Picture, as shown below: *Import data from a picture requires a Microsoft …
When you hover your mouse over an element in a visual, like a column in a clustered column chart, a tooltip like this appears. The mouse is over the first orange column so the tooltip is showing the country, year, and sale total for that column. The country could be removed as you can tell …
Conditional formatting in Power BI visuals allows you to draw attention to, or highlight, data in text or numeric fields using color, icons or data bars. You can also assign URL's to fields to make them clickable and load web pages. Let's look at how to apply all of these different types of conditional formatting. …
When you import data to Power Query, it's not unusual to end up with a table containing blank rows and columns, like this There are a few ways to get rid of these 'blank' rows and columns, some better than others. Watch the Video Download Example Excel Workbook Enter your email address below to download …
You may have data that is contained in lists or records, or even lists inside records, or records inside lists. I've seen nested data like this come from API's or Sharepoint amongst other sources. In such cases you may want to extract only certain bits of data from the list(s) or record(s) and this blog …
Writing DAX is hard enough. If there were some way to make the experience a little easier wouldn't that be great? To that end, below is a list of keyboard shortcuts you can use in the Power BI Desktop DAX Editor. Watch the Video To See What These Shortcuts Do Download DAX Editor Shortcuts PDF …
I'm going to look at situations that appear to be fairly common: loading data into Power Query where the source data has columns with different names. For example, in the following file received in August 2021, I have data that relates to various items over a 12 month period. What the data is showing is …
Typically in Power BI visuals like a matrix or a table, and in pivot tables in Excel, we expect the totals to be the sums of the individual rows. This is probably because we are so used to adding up columns in Excel. In this example image (below) I've written a measure called [Target] to …
