556 attributed reviews in the last 3 years
Refreshingly small course sizes
Outstandingly good courseware
Whizzy online classrooms
Wise Owls only (no freelancers)
Almost no cancellations
We have genuine integrity
We invoice after training
Review 30+ years of Wise Owl
View our top 100 clients
Changes to Power BI Desktop in the November 2023 update
Part four of a four-part series of blogs
Although the main innovations in this update are in preview, two of them are turned on now by default: button slicers and reference labels for cards. We also can't resist the temptation to show the new DAX query view, even though it's still very much in preview only.
I'm breaking my self-imposed rule with this part of the blog, as the DAX query view tab is in preview and is not yet turned on, but surely a quick peek can't hurt?
There have been 3 buttons on the left since Power BI Desktop began, I think, so a 4th button is quite an event!
You can now use the sheet which appears when you click on the button shown above to create your own DAX queries - but I've cheated and created a quick query to show the first 100 regions (although there are only 9 in the database as it happens):
You can right click on any table and generate a quick query.
This will give you a DAX query, which you can then run:
I added the comments after Power BI had done its stuff.
Running any query shows the results at the bottom of the pane:
The output from the above query.
I can now give this query tab a name:
I've called this Top 100 regions.
This window will be really useful for debugging and for evaluating data in a model. Microsoft have said that they are going to keep adding features to the window, so perhaps it may be a few months before it emerges from preivew purgatory.
|Parts of this blog
25 Aytoun Street