Jeff “This is your Copilot speaking” Weir

I like talking about data visualisation and actionable insights in Power BI, and pushing for better vis & UI/UX. See my sample file here:

[Jeff “This is your Copilot speaking” Weir @InsightsMachine]

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".

[Jeff “This is your Copilot speaking” Weir @InsightsMachine]

@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

[Jeff “This is your Copilot speaking” Weir @InsightsMachine]

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

@myersmiguel

[Jeff “This is your Copilot speaking” Weir @InsightsMachine]

@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

[Jeff “This is your Copilot speaking” Weir @InsightsMachine]

@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)

[Jeff “This is your Copilot speaking” Weir @InsightsMachine]

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

[Jeff “This is your Copilot speaking” Weir @InsightsMachine]

@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),

[Jeff “This is your Copilot speaking” Weir @InsightsMachine]

@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 💩”

[Jeff “This is your Copilot speaking” Weir @InsightsMachine]

@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.

[Jeff “This is your Copilot speaking” Weir @InsightsMachine]

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

[Jeff “This is your Copilot speaking” Weir @InsightsMachine]

@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?

[Jeff “This is your Copilot speaking” Weir @InsightsMachine]

@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?

[Jeff “This is your Copilot speaking” Weir @InsightsMachine]

@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.

[Christopher Webb @cwebb_bi]

@KerryKolosko No, definitely not. But when customers have very strong desires and your competitors are rushing to meet them, you ignore these desires at your peril.

[Jeff “This is your Copilot speaking” Weir @InsightsMachine]

@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.

[Jeff “This is your Copilot speaking” Weir @InsightsMachine]

@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.

[Jeff “This is your Copilot speaking” Weir @InsightsMachine]

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

[Jeff “This is your Copilot speaking” Weir @InsightsMachine]

@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.

[Jeff “This is your Copilot speaking” Weir @InsightsMachine]

@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.

[Jeff “This is your Copilot speaking” Weir @InsightsMachine]

@ExcelHumor You lucky, lucky bastard.

[Jeff “This is your Copilot speaking” Weir @InsightsMachine]

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

[Jeff “This is your Copilot speaking” Weir @InsightsMachine]

@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)😀