BY TOPIC▼
POWER BI BLOGS▼
POWER BI BLOGS▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
Wise Owl Training - Power BI blogs (page 1 of 7)
Showing blogs 1-20 (out of 137)
The Magic of the Power Query SHARED Global Environment
Posted by Andy Brown on 26 July 2021
How to use the #shared keyword to bring up a list of all of the M functions in Power BI Query, and then use this list to create your own help table or even your own function.
Posted by Andy Brown on 26 July 2021
This month's update sees the launch of small multiples, a range of new dynamic format properties and the roll-out of sensitivity labels.
Showing Small Multiples in Power BI charts
Posted by Andy Brown on 26 July 2021
Small multiples are mini-charts shown in a two-dimensional grid, with each chart showing the state of play for a different field's value. After a number of improvements small multiples have finally emerged from preview!
Posted by Sam Lowrie on 19 July 2021
Sometimes our Owls come across little titbits that aren't big enough to count as a full meal. Instead we bide our time and create a smorgasbord of little bites for you to feast on. With that in mind, here are 5 Power BI tips that you might not know.
Power BI Reports vs. Paginated Reports
Posted by Andrew Gould on 19 July 2021
Confused about the difference between Power BI Reports and Power BI Paginated Reports? Allow this blog to clear up the confusion!
Power BI Channels you should watch
Posted by Sam Lowrie on 01 July 2021
There are many great resources for learning Power BI, and so many of them are completely free! Level up your BI skills with some of the best. Here Sam covers some of his favourite BI channels. You even get a glimpse behind the curtain to see other channels he watches!
Useful short-cut keys for use in the DAX formula editor
Posted by Andy Brown on 30 June 2021
DAX contains a number of incredibly useful hidden short-cut keys, allowing you to move lines, comment code and much more!
Power BI Desktop update - June 2021
Posted by Andy Brown on 29 June 2021
This update only includes a couple of tweaks for charts, although more excitingly the paginated reports visual is now in preview.
Creating picture charts in Power BI using the Infographic Custom Visual
Posted by Andy Brown on 19 May 2021
Want to use your pet's picture for a column chart? This blog shows how to create stacked picture charts in Power BI using the powerful Infographic custom visual.
Power BI Desktop update for May 2021
Posted by Andy Brown on 19 May 2021
May's update to Power BI Desktop is a big one, encompassing new ways of viewing models, tables and fields, a new text box, smart narratives (to explain data) and a new anomaly detection feature (to explain exceptions).
Details of the Power BI Desktop Update for April 2021
Posted by Andy Brown on 28 April 2021
The April 2021 update to Power BI Desktop makes it easier to load text, CSV, JSON and Excel files and includes a wider range of shapes, with more drawing effects
Solving FAILED TO DECRYPT CREDENTIALS message when running Power BI
Posted by Sam Lowrie on 20 April 2021
Following the April 2021 update to Power BI (perhaps coincidentally) we started getting this message appearing on our computers, blocking us from running Power BI. Here is how to solve this!
Power Query Online now supports flow diagrams!
Posted by Andy Brown on 24 March 2021
A life-changing (or at least job-changing) new software update from Microsoft - you can now see a visual view of data flows in Power BI (at least in the online version, anyway).
Power BI Desktop - March 2021 Update
Posted by Andy Brown on 24 March 2021
There are two tiny changes in the March 2021 update - X-axis constant lines and a couple of tweaks to DAX - but still the big logjam of changes remains in preview.
Colouring the table row for a selected item in Power BI
Posted by Andy Brown on 22 March 2021
How can you highlight the row in a table corresponding to the slicer value you've chosen? With a disconnected slicer and a clever measure!
Changes to Power BI in the February 2021 update
Posted by Andy Brown on 26 February 2021
After no update in January, February sees just a couple of small changes to Power BI, but there's a big logjam building up in preview.
Showing DAX Studio and Tabular Editor as external tools in Power BI
Posted by Andy Brown on 23 February 2021
Power BI automatically creates an External Tools ribbon when you install the Power BI, Tabular Editor and ALM Toolkit add-ins.
DAX.DO - a replacement for DAX Studio?
Posted by Andy Brown on 22 February 2021
The legendary Marco Russo has launched a new web-based DAX editor, but can it compete with or even replace DAX Studio?
Errors when you delete a primary key in Power BI
Posted by Andy Brown on 22 February 2021
Be careful of referencing measures in calculations when you have duplicate rows in a table! This blog explains why you might want to hang on to that unused primary key column.
How to use DAX to show for each row of a table its share of the maximum value
Posted by Andy Brown on 22 January 2021
How can you show each aggregate value in a group as a percentage of the highest aggregate value? This blog shows two ways to use DAX measures to solve this deceptively difficult problem.