Other changes in the April 2020 Power BI update

Other new features introduced into Power BI in this month's update include the ability to conditionally format totals in matrices and tables and improvements to Query Diagnostics and Q+A visuals.

Conditionally formatting totals in tables and matrices

When applying conditional formatting to the values in a table or matrix, you can choose the scope of this change:

The new drop down when applying conditional formatting.

Here's what you might get when you choose Values and totals in the dropdown above:

I've gone from a minimum of 0 (light pink) to a maximum of 20,000 (red).

When you choose any option other than Values only you have to set a custom minimum and maximum value:

You can't choose Lowest value from this dropdown when you choose to format totals (not quite sure why).

In a slightly apologetic update note, Microsoft say:

Clearly there is more planned for this feature!

Improvements to Query Diagnostics

This feature was introduced in last month's update, and I explained how to use it then:

You can tell Power BI to time how long it takes different visuals or queries to load.

However, the Diagnostic Options button above is new.  Clicking on it brings up this dialog box:

Performance counters introduce yet more options to log resource usage every half-second.

I feel I'm running the risk of losing readers at this point!

Improvements to the Q+A visual

Microsoft's obsession with this feature continues - it receives more love than almost any other part of Power BI.  From this month Power BI will suggest questions to ask:

For the Wise Owl Create-a-Creature database, here are the questions Power BI suggests asking.

For those who like Q+A visuals much more than I do, you can also now create new vocabulary based on measures in your model, and not just on calculated columns.