GoatShipMate's Avatar

GoatShipMate

@goatshipmate

Data Analyst mainly posting work-arounds for #PowerBI #PowerQuery #Excel etc, but also posting about #DataVisualisation in general. #ThirdSector #Charity #DataViz. I'm an #ActualPerson – my pseudonym is due to my job's social media policy

87
Followers
133
Following
516
Posts
15.11.2024
Joined
Posts Following

Latest posts by GoatShipMate @goatshipmate

Pausing PowerBI discussion briefly just to acknowledge how good MAGNOLIA is...

06.03.2026 15:37 👍 0 🔁 0 💬 1 📌 0

I always forget the implicit ones are classed as measures.

06.03.2026 11:02 👍 0 🔁 0 💬 0 📌 0

Do tell.
I'm getting strong got-their-technical-questions-off-the-internet vibes.

06.03.2026 10:59 👍 1 🔁 0 💬 1 📌 0

I set mine to start every reply with M'lud, initially just as a test, but it still mildly amuses me.
But yours is on a whole other level. Following just on the basis of that.

06.03.2026 09:45 👍 1 🔁 0 💬 1 📌 0

It's a really nice idea, but I feel Plato's contribution is somewhat undercooked...

06.03.2026 09:38 👍 1 🔁 0 💬 0 📌 0

I like to think I'd challenge the premise of the question.

(Because at its most basic level I'd say the divide is between Power Query/ M code and DAX [both of which have functions], but if that's what they were driving at, it's a really weird way to ask about it.)

06.03.2026 09:35 👍 1 🔁 0 💬 1 📌 0

Thank you :)

05.03.2026 12:29 👍 0 🔁 0 💬 0 📌 0

I'm stuck in PowerBI where the options are still quite limited. May I ask what you're using which is good, because I might need to get into that a bit?

05.03.2026 07:58 👍 0 🔁 0 💬 1 📌 0

If we beat Wolves and Burnley at Elland Road we're on to 37 points. That leaves 7 games to harvest an extra point or three. (Including West Ham on the final day.)

05.03.2026 07:51 👍 0 🔁 0 💬 1 📌 0
Post image

Things have got a bit tighter after the last 2 disappointing results, but we're still 8pts ahead of where I thought (at the start of the season) we needed to be at this point to survive. Can't afford many more slips up like last night though. #LUFC #MOT #DataViz

04.03.2026 18:01 👍 3 🔁 0 💬 1 📌 0
Preview
How does Five9's call log code its calls

New blog post: possibly my only one for the year...
"How does Five9's call log code its calls?"
charitydatageek.blogspot.com/2026/02/how-...

04.03.2026 09:45 👍 0 🔁 0 💬 0 📌 0

Thanks,
I think my unease with it is on 2 levels.

On one level I accept the majority view is that it's OK for line charts
(even tho' I would argue the relative changes are still expressed relative to the position of that 0 line)

but also, in this specific case, I do think the scale is misleading.

04.03.2026 09:29 👍 0 🔁 0 💬 0 📌 0

I'm less happy about the y axis on the top one, however.

03.03.2026 14:10 👍 0 🔁 0 💬 1 📌 0

I'd say they can have that suggestion for free, but they just steal everything anyway...

26.02.2026 14:15 👍 0 🔁 0 💬 0 📌 0

I can't help wondering if AI providers would do better if they shaded my prompts with a different colour so when I'm scrolling through our chats I can quickly identify where I am. They tend to be very verbose and trying to get back to something useful is an annoying part of the process.

26.02.2026 14:14 👍 0 🔁 0 💬 1 📌 0

#PowerBI just did that thing again where is turns off a scheduled refresh because no-one has viewed the report.
No warning.
Really annoying.
It's not there for the reports to be viewed, but for the data to be processed via #Flow.

25.02.2026 09:33 👍 2 🔁 0 💬 0 📌 0

Thanks for highlighting that. It's a good list.

19.02.2026 19:09 👍 0 🔁 0 💬 0 📌 0

Came across this old #PowerQuery tip. It's a good one.

19.02.2026 11:31 👍 1 🔁 0 💬 0 📌 0

Took my first few baby steps into R yesterday to clean some data using #Regex. Need to focus more on other skills, but this was the best tool for the job given I wanted to stay within #PowerBI

19.02.2026 09:41 👍 0 🔁 0 💬 0 📌 0

We stayed in the house he was born in in Pisa. It's broken into different apartments now and one of them is on AirBNB at a normal cost.

17.02.2026 08:44 👍 0 🔁 0 💬 1 📌 0

Once, during a rugby match, they super-glued up a gash in my forehead, and I went back on and scored a try.

16.02.2026 09:35 👍 0 🔁 0 💬 0 📌 0

No really relevant to my usual MO here, but I love this story, and not just because I am a 6'5" man who lives in what would've been Mercia.

13.02.2026 08:30 👍 0 🔁 0 💬 0 📌 0

...Tho' remember if you're bringing it in to #PowerBI to change QuoteStyle=QuoteStyle.None
to
QuoteStyle=QuoteStyle.Csv

12.02.2026 10:39 👍 0 🔁 0 💬 0 📌 0

Thanks. I panicked for a moment, but as someone that always builds from Desktop I think I should be OK.

11.02.2026 09:52 👍 0 🔁 0 💬 1 📌 0

Think I'm going to have to start adding a date to my code comments so I can find the AI conversation that led to them. Probably documenting them better in the first place would be better, but it's a start.

10.02.2026 14:22 👍 1 🔁 0 💬 0 📌 0

Thanks. That makes a lot of sense. Up to now I usually curse and spend ages incrementally increasing & decreasing the widths/lengths until I get the larger font size in the smallest possible box. Your way definitely sounds better.

09.02.2026 19:51 👍 1 🔁 0 💬 1 📌 0

Ace. "Barsky" is a nice touch

09.02.2026 19:48 👍 0 🔁 0 💬 0 📌 0

Well that makes me feel a lot better!

09.02.2026 10:44 👍 0 🔁 0 💬 0 📌 0

Agree with you on the first, though still thinking through everything around the second. Out of interest, what makes you say that?

09.02.2026 10:44 👍 2 🔁 0 💬 1 📌 0

I'm embarrassed to admit I've been using #PowerBI for nearly 5 years and I've only just discovered that you can stop it shrinking your label text etc. by going to
Format>Properties>Advanced Options and setting "Responsive" to Off.
I know there are other implications of turning that off, but still!

06.02.2026 10:04 👍 4 🔁 0 💬 3 📌 0