Jeff “This is your Copilot speaking” Weir

Hey y'all...I'm looking for my next Datavis gig with the *exact* right mix of "I won't professionally compromise" and "but that's quite the hourly rate".

@marcorus @myersmiguel For anyone following along at home, here's the issue: I get a different result depending on whether my slicer is in "Between" mode or some other mode. @myersmiguel

@InsightsMachine @myersmiguel IDK send me a repro

I found what appears to be a bug when using the Advanced Filter on a numerical slicer. @myersmiguel

@myersmiguel @marcorus Here's the relevant tables. Note that Year[Year] has a different max value (2004) than Time[Year], and this seems to cause the DAX to return the wrong result when a "Between" slicer used

@myersmiguel ^ @marcorus I wonder if you can confirm whether this is a DAX issue, or as i suspect a bug in Slicers in "Between" mode (and not the first potential bug I've raised regarding "Between" Slicers with Microsoft that has gone nowhere)

@marcorus ^ Better just to make my measures that are called by the FP conditional. Stand down.

@marcorus I wish you could conditionally change the measure called by a Field Parameter, based on a Slicer. The below syntax isn't illegal, but doesn't work. ("Category", IF([True Or False],NAMEOF([MeasureA]),NAMEOF([MeasureB])), 1),

This article+video describes how to apply conditional formatting on measures picked from a slicer and implemented using two different techniques: field parameters and calculation groups. #powerbi #dax sqlbi.com/articles/using…

@KerryKolosko @cwebb_bi If I had the ability to edit that and an audience of geologist data analysts I would have said “I get that there is a gold rush going on, but mostly it looks like a Pyrite of 💩”

@KerryKolosko @cwebb_bi In mine it’s often the price. I don’t think Gartner factors in much in my government town. But god forbid someone should edge past MS on the quadrant based on higher investment in Clippy 2.0 I get that there is a gold rush going on. I’m just yet to see the gold.

Why would you use #PowerBI Copilot? blog.crossjoin.co.uk/2024/10/13/why…

@JeffKomen @cwebb_bi @KerryKolosko Damn you Jeff you are right.

@InsightsMachine @cwebb_bi @KerryKolosko In tableau?

@cwebb_bi @KerryKolosko But this has been my entire complaint about #PowerBI’s visual capability for ever, and it irks me no end that resources are getting applied to copilot for hapless C level execs who will QUICKLY realise copilot don’t deliver, and meanwhile where is my Tableau-level viz capability?

@cwebb_bi @KerryKolosko TBH if I was in the business of selling #PowerBI licenses I’d probably do the same. But because you mention it in your post @cwebb_bi I feel compelled to ask: Has anyone here met these C-level execs who supposedly deliver organisational value using Copilot for #PowerBI?

@cwebb_bi @KerryKolosko I think I’d rephrase it like this: When Gartner have very strong Magic Quadrant criteria and your competitors are rushing to meet them in order to bedazzle C-Level Execs, you fulfil these criteria regardless of whether it truly improves the product.

@cwebb_bi Never mind the fact that there is a circular relationship between modelling and visualisation in meaningful report development m. Heck, if I were assimilated into copilot I would require write permission to *add* to the data model to produce maximum (sometimes minimum) insight.

@cwebb_bi Copilot’s gonna get in their heads enough to add insight? Occasionally perhaps. I’ll give you that copilot will produce meh reports cheaper than humans currently producing meh reports. But the better reports will be hidden in a sea of meh as C-Level execs race to the bottom.

@PhilSeamark Did they announce #powerbi audit bookmarks mode yet? Because we’re *really* in the dark there…

#powerbi dark mode

@kurtbuhler I just turned out a pretty good dashboard in 2 weeks with the tool. I’m gonna have to spend the next 2 documenting the hacks that made it good. I can’t imagine how hard it must be to build a principled tool, mind. But I wish the tool’s makers could see how hard I have to hack.

@kurtbuhler I don’t like commenting here, but have to say that I must have screwed up because I’ve made criticising my mf tool *part* of my identity. TBH I’m quite good at the tool partly bc it’s quite bad. I get relatively good results bc I hack the mf tool like the stubborn mf I am.

Stop falling in love with hammers -- Too many people fall in love with products, tools, features & technology. Nothing fits every scenario. You can deliver better outcomes and learn more when you think about it this way. Use hammers for nails and use screwdrivers for screws.

@ExcelHumor You lucky, lucky bastard.

@marcorus You want a good data analyst? Hire the high-functioning lazy kid.

@marcorus Actually my analytical skills are derived from analysing data using Excel, and for that I owe a massive debt to John Walkenbach (who taught me how to be lazier when using it) and Jon Peltier (who taught me how to be lazier by leveraging the visual cortex that Darwinism gave me)😀

Honestly, you should look for three skills in a data analyst. Probably not what you think! #Honestly #dataanalyst #skills