The new DAX query view

This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

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. Changes to Power BI Desktop in the November 2023 update You can now create button slicers (the first of 5 new types of slicer, apparently) Reference labels for cards The new DAX query view (this blog) We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI courses.

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.

Changes to Power BI Desktop in the November 2023 update
You can now create button slicers (the first of 5 new types of slicer, apparently)
Reference labels for cards
The new DAX query view (this blog)

We've been creating our idiosyncratic monthly blogs on Power BI updates since November 2016, and also deliver online and classroom Power BI courses.

Posted by Andy Brown on 11 December 2023

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
Changes to Power BI Desktop in the November 2023 update You can now create button slicers (the first of 5 new types of slicer, apparently) Reference labels for cards The new DAX query view (this blog)