Have a measure that you want to format as a string in Power BI? But then the sorting doesn't work on it? What do you do? You can't sort by column with Measures. Patrick shows you how you can leverage Dynamic Formatting! Create dynamic format strings for measures https://learn.microsoft.com/power-bi/create-reports/desktop-dynamic-format-strings Zoe Douglas: https://twitter.com/datazoepowerbi https://www.linkedin.com/in/zoedouglas-data/ Phil Seamark: [...]

Don't ignore Dual Mode! If you are leveraging DirectQuery and Import in your Power BI semantic model, you could have some performance problems you aren't aware of. Patrick shows you what's going on!

Think you are using the same data source in Power BI? Maybe you aren't? Patrick shows you how this can affect DAX Query performance and how to correct it.

It's been a long time coming but Visual Calculations within Power BI are here!!! Jay joins us to get us started on using Visual Calcs within our reports. Share your thoughts on visual calculations (preview) https://aka.ms/visual-calculations-feedback Using visual calculations (preview) https://learn.microsoft.com/power-bi/transform-model/desktop-visual-calculations-overview Jeroen (Jay) ter Heerdt https://twitter.com/JayPowerBI https://www.linkedin.com/in/jeroenterheerdt/ https://www.dutchdatadude.com/

Someone asked how to exclude Top N results within Power BI. Patrick goes on an adventure to explain using DAX. DAX Query View to the rescue!

We got the question if you could use Field Parameters with Direct Lake in Power BI. The answer is, yes? However,... Patrick tells more! Let report readers use field parameters to change visuals (preview) https://learn.microsoft.com/power-bi/create-reports/power-bi-field-parameters Direct Lake https://learn.microsoft.com/power-bi/enterprise/directlake-overview Tabular Editor https://tabulareditor.com/ Tabular Editor Script https://github.com/tabulareditor/Tabulareditor3/issues/541

A live stream question asked if you could create a DAX measure from a filtered visual in a Power BI report. Of course, you can! Patrick uses the new DAX Query view in Power BI Desktop to show you how.

We got a new DAX Query view within Power BI Desktop and it's INSANE AMAZING! Patrick shows how you can leverage the new feature. Work with DAX query view https://learn.microsoft.com/power-bi/transform-model/dax-query-view Power BI November 2023 Feature Summary https://powerbi.microsoft.com/en-us/blog/power-bi-november-2023-feature-summary/#post-25061-_Toc150157949 Deep dive into DAX query view and writing DAX queries https://powerbi.microsoft.com/en-us/blog/deep-dive-into-dax-query-view-and-writing-dax-queries/