Randal Dale

Thank both of you for your great content

Under "Why do we need it?" you must cross a critical threshhold: Because the platform does not deliver this benefit out of the box. In order to give an honest answer developers must be humble. Did you explore all options or did you give up early and go for the workaround?

good stuff! A relativeily simple way to improve the look of forecasts. I like it.

@HavensConsulting to display dynamic 'measure names' I am using a calculated table 'Filter T', the result of a crossjoin between my parameter field table with a date table. This 'Filter T' is related to the parameter table. Doing it this way the custom order does not work, have you come across this? Is there any workaround? P.D: For context, the user is selecting a month and I have done this so instead of showing a measure as 'EoM Sales' or 'Week-1 Sales' it displays the date based on the filter selected (e.g. 'EoM Sales' measure is displayed as '2024-03 Sales')

Mate I saw a few videos on the topic, but your was the easier to follow and with the simplest calculation. Thank you

Exactly -> precaclucation of time intelligence for front-end speed benefits would be so cumbersome in power query, but even it databricks

Great examples! Thanks!

Could you please me how can use multiple fields parameters with help of data modeling

Really great video, thank you very much for it. I think we all really value your posts on Linkedin, Injae, and thanks Reid for having these discussions. Best regards

Leila Gharani’s big success is due to her training on Excel. There is far more Excel users than PBI. She has very good knowledge, tips, tricks and courses. My 1st Dashboard design course was her one and it was in Excel.

Friends, please activate subtitles

Thank you for sharing this. I would like to ask a question I can't find after googling a lot: I converted a filtering measure to calculated groups. It works as expected, but it doesn't appears in report view's data pane as a calculation item... I can see & work with it in model pane, but in data pane I can expand only calculation group and calculation group column... why's that?

I'm trying to create a custom PostgreSQL connector that used Microsoft Entra Id as the authentication method with the Power query SDK. As a test I'm trying to just recreate the PostgreSQL connector that is already in Power-bi with UsernamePassword authentication. This is my .pq file // Main function to connect to the PostgreSQL server [DataSource.Kind="PostgreSQLConnector", Publish="PostgreSQLConnector.Publish"] shared PostgreSQLConnector.Contents = (server as text, database as text) => let // Connect to PostgreSQL without hardcoding credentials result = PostgreSQL.Database(server, database) in result; // Publish metadata PostgreSQLConnector.Publish = [ Beta = true, Category = "Database", ButtonText = { Extension.LoadString("DataSourceButtonText"), Extension.LoadString("DataSourceButtonHelp") }, SourceImage = PostgreSQLConnector.Icons, SourceTypeImage = PostgreSQLConnector.Icons, SupportsDirectQuery = true ]; // Data source definition and authentication PostgreSQLConnector = [ Authentication = [ UsernamePassword = [] ], Label = Extension.LoadString("DataSourceLabel") ]; But I'm getting the error that I need to specify how to connect. I try to do this with Odbc.DataSource in stead of PostgreSQL.Database and this works but I don't want the need to install a PostgreSQL driver locally.

Really interesting topic.Well presented with use cases.

Just be careful with this calc group as it will replace any measure, and this may bring unexpected consecuences. It's safer to scope it to a certain base measure (e.g. [dummy]) and leave other measures as SELECTEDMEASURE () (i.e. Untouched)

I like this guy.

Very useful & insightful - thanks to you both! Any chance of getting the starting data model to work along?

Brillant demonstration, Tristan

I was one of those people who always tried to avoid calculated columns with dax. Thanks for showing me that I was wrong. There are some scenarios when the result is much better with dax-calculated columns.

Thanks for insightful session on & in Dax.

Really glad someone with the necessary chops has finally stepped up and thoroughly debunked that silly "no DAX columns, EVER" position once and for all. Thanks, Tristan and Reid!

Kudos for you, man, for finding an extremely convoluted way to perfom a simple task of hiding column in a matrix. Not only it is difficult to undestand and manage, I will probably forget all about it in few months time, and I'll completely loose track of it. Moreover, your method kind of abuse the concept of calculation groups, as it doesn't provision for the reduction of the overall number of measures. It is mind boggling to me that one have to go all this trouble just to put some numbers in a matrix. But that Microsoft for you. I'm wandering were do they find all these great, great coders, and were do they find the managers which approve such great work. I think this is MS true specialy. Create SW which you have to work for rather than the other way around. It is hard to understand how MS could have neglected to provide such a simple feature already 3 yrs after you posted this video.

I have 10 levels of hierarchy, when I add them into field one by one, the first 3 levels are working fine, but when I start to add the following levels in from level4, the values display in my level 2 are gradually disappearing.

Do you need to use a data lake or similar for this?

Thanks, why does microsoft have to shoot me in the foot.

If I want to make new measures, if I create them in the MyMeasures table that was in the dataset file I published, and I add a new measure in the report file under that web connected MyMeasures table, will the measure be pushed into the cloud service or am I supposed to always add new measures to the dataset seperated version and always have to publish and refresh every time?

Genius - thank you

I second the perspective feature. This would be really helpful to have it available in the UI right when you connect to a semantic model.

Sandeep, is there a way to use notebooks or semantic link to back up and restore power bi semantic models? If yes can you point me to some documentation or show us how? Today I have to use powershell or ssms. Thanks.

Hey Reid, awesome explanation, thanks a lot. Can you please share the demo pbix file?

Understanding the overall benefit, I still have one question. What performance difference is there, if any, between doing this and simply having the originating report and dataset in place, and simply attaching to that originating dataset as needed for other reports? All of these dependencies look the same in the Power BI Service, whether split or not.

Once a report is created using PBIR format, can it be reverted back to the old format? Saving it as .PBIX doesn't seem to work for me, as I still get the same warning and inability to publish.

When we generate dates in power BI dax, such as "date(2024,8,30)", it says these will return the date in datetime format. Do you know which of the three datetime formats these are loaded in?

Hi Folks, thanks for this! This is fantastic. With the new PBIR format, deleting everything after objects wasn't working properly. So, to have it working, I removed everything between brackets. The result was: "objects": { "merge": { "outspacePane": [] }

i have been searching for a week on how to do this, you're a life saver , great content

This works if no dates can be selected on the page, ie. the solution doesn't have to be dynamic. At the beginning of a new year I imagine they would want to look at data from the perspective of the last year, still, for a while. Otherwise a disconnected table with the CY and PY columns would have to be created and the measure adapted to the new context.

Hi Reid. Thank you very much for the tutorial. Please, I have a question about the slicers, how did you change the circle in the slider into a vertical bar ? Thank in advance

Starts at around 18 minutes

This was kinda interesting but way beyond my current level. Just trying to work out how the process of coding in vs would work and how I would then get the code back into the PBI report? Is it a manual process? I think it was alluded to in the SDK discussion, but not clearly enough for a simpleton like me...

thank kiu vm, love<3

One of this channel's best sessions. Thanks a lot

I think AI is very helpful when you already know the basic technology and help you forward. It's another tool.

I was struck with similar issue and this video helped🙏

I'm pretty interested in using DBT with Fabric because our org has more in-house SQL knowledge than python. Since this video, have there been any advancements in the ability for Fabric to orchestrate DBT Core? Is there any information about whether there are any issues with the types of SQL Commands that DBT attempts to use with the warehouse? For example, the MERGE function is not supported in Fabric Warehouses at the moment, does the DBT Fabric Connector explicitly block the usage of MERGE? Last question: If the default method for loading data into a table is to DROP and then CREATE the table again, then relationships can't be made in the Warehouse (Fabric doesn't let you drop tables that have a relationship to another table). How are other users getting around that? If you aren't able to create relationships, does that block users from using Direct Lake mode with that warehouse? Or is there a way to tell DBT to TRUNCATE instead? @johnnyw5627 Thanks for the video!

Cringey AI photos

I have 3 measures. Sales CY, Sales PY, and Sales YoY. Sales YoY Dax is just simply Sales CY - Sales PY. Requirement is these 3 measures each have to be in their own column of a visual table to allow sort. When I try to optimize the Dax using Dax studio I find that the YoY measure is taking the longest naturally. Is there a way to tell that column just to use the queries from CY and PY measures already being sent from the other two columns. I am sending three queries and don’t want to. I only want to send 2. I was really hoping visual calcs would solve this. Essentially I want to only send queries necessary. Then YoY or YoY % I want to simply just use the already run queries. Simply put I want to only query a measure once but then use it in multiple columns in different ways. Any thoughts?

Can We find somewhere the DAX code that was used to complete the new visual card with a line graph , ...

Hi Reid, I got a similar quesion and solved it via the creation of specific conctional formatting measures like this: 1/ Determine the MAX and MIN value over all the involved measures: ConditionalFormatting_MaxValue = Max( Max( Max( Max([RollingAvg_SalesInvoiceAmount_Previous12M_Dynamic], [RollingAvg_SalesInvoiceAmount_Previous3M_Dynamic]) , [RollingAvg_SalesInvoiceAmount_Previous6M_Dynamic] ) , [DailySalesAmountProjected] ) , [RollingAvg_SalesInvoiceAmount_PreviousYear] ) & ConditionalFormatting_MinValue = Min( Min( Min( Min([RollingAvg_SalesInvoiceAmount_Previous12M_Dynamic], [RollingAvg_SalesInvoiceAmount_Previous3M_Dynamic]) , [RollingAvg_SalesInvoiceAmount_Previous6M_Dynamic] ) , [DailySalesAmountProjected] ) , [RollingAvg_SalesInvoiceAmount_PreviousYear] ) 2/ For each measure then calculate the % difference from the max , compared to the Max-Min Difference : ConditionalFormatting_Rolling12M = IF( [RollingAvg_SalesInvoiceAmount_Previous12M_Dynamic]> 0 , 1 - ([ConditionalFormatting_MaxValue] - [RollingAvg_SalesInvoiceAmount_Previous12M_Dynamic]) / ([ConditionalFormatting_MaxValue] - [ConditionalFormatting_MinValue]), BLANK() ) ....... And use these "conditional formatting measures" in the conditional formatting definition of each field. I used it for background colors. For bars maybe it will not work ....

In my case your solution didn't work copied it step by step, syncing slicers doesn't override the drill-through filter for me it basically just layers on the filters, not sure why yours works