BLOGS BY TOPIC▼
BLOGS BY AUTHOR▼
BLOGS BY YEAR▼
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).
- Power BI Desktop update for May 2021
- A new model view
- Standardised table and field lists across Power BI views
- New text boxes (this blog)
- Smart Narratives
- Automatic detection of anomalies
Posted by Andy Brown on 19 May 2021
You need a minimum screen resolution of about 700 pixels width to see our blogs. This is because they contain diagrams and tables which would not be viewable easily on a mobile phone or small laptop. Please use a larger tablet, notebook or desktop computer, or change your screen resolution settings.
New text boxes
This feature wasn't announced separately in Microsoft's monthly update blog (instead the new text box was quietly introduced to support the new smart narratives feature). Here's what Power BI text boxes now look like:
The text box menu has changed, and (as the rest of this page will show) you can now display dynamic values in text boxes too.
The most irritating feature of text boxes hasn't changed, sadly: to change the format of text, you still have to click and drag to select it (unlike in just about every other Microsoft application, it's not sufficient just to click on the edge of a text box to select its text).
Adding values to text boxes
Strangely, you can now ask Power BI to show dynamic values in a text box at a particular position:
Click on the Value button shown to display a new value.
You can then use a combination of field names, functions, guesswork and responding to prompts to build up a formula:
Here I want to show the total quantity sold for all regions.
Below I've formatted my number, and given it a name (Total sales):
The new value I've created.
The result looks seamless:
The resulting figure appears within the text in the text box.
Values are dynamic
When you add a value to a text box, you are actually inserting a dynamic formula:
The total is now showing as 4,777 because you've clicked on the North region column in the chart.
If a card visual and a Q&A visual met in a night-club and ended up having a love-child, the new text box might be the result!
Reviewing (editing) values
You can show, edit and add to your list of values as follows:
Click on the Review tab to look at the values displayed in a text box.
You can now click on any value to change its definition or appearance:
Here we're only showing one value for the text box.
Values are local to a text box: you can't refer to a value created for one text box in a different one.
Microsoft have invested a lot of money in making it possible to create formulae in Q&A visuals without writing any DAX, and have obviously decided to carry this functionality into a text box. I think DAX programmers' jobs are still secure for now, though!