Last seen: Jun 29, 2026
Hi Digalo, Thanks for the sample file. In the attached Excel file you'll see a query with your segments. Note: some keywords contain multiple 'F...
Ooh, Bax, you've broken a fundamental data structure rule that is to never nest headers across more than one row, and this is making the task of conso...
Hi Cele, I can't see your queries because they're referencing files on your K drive, which I don't have. I created new queries from the PriorYr ...
That's correct. The data types are really for loading the data into Power Pivot where data types are used in the modelling. When you load the data int...
Ok, perhaps you can upload a sample Excel file so we can get a feel for the data you're working with and offer a suitable solution. Mynda
You're most welcome, Elinor. It's great to know we can help.
Hi Digalo, You can use the Merge tables technique shown in session 3.04 to bring the 'segment' data into your data table from a lookup table. e....
Hmmm, Gremlins! Are you able to share the file with me so I can reproduce the error and try to understand the cause? Mynda
Hi Digalo, What formatting did you do in Power Query? Power Query is really for setting data types, Excel is where you apply cell formats. Mynda
Hi Elinor, Although Sunny has provided you with a formula that will work, take heed of his warnings and consider them a reason not to use the formu...
Hi Cele, If you click on the error link you'll get a list of the errors, although I find it's often easier to edit the query and look for the colum...
Hi Adele, Have you tried the Power BI Custom Visual Bullet Chart? It's pretty easy to set up. There's also a custom visual called 'Ultimate Varianc...
Hi Aleksandrs, Have you tried using Power Query to get the data and then set the data type for the column with 'Change using locale' as shown in le...
Hi Albert, Goal Seek can alter one value at a time to achieve your desired result. It can't alter all variables; i.e. rate, nper, pmt and PV, and i...
Hi Paul, You need to use the 'Sort by' setting as shown in session 4.05 of the Power Pivot course. You may need to add a column that contains a num...