OK I'm on 99 followers. Anyone want to recommend me to help me get into triple figures?

If you're in #Excel charts and trying to get the chart to rescale when you add/copy down more rows... use named ranges and put the formula as =Sheet1!$B$2:INDEX(Sheet1!$B:$B,COUNTA(Sheet1!$B:$B) +2) Then add the named range to the chart's "Select Data Source" window #DataViz #ExcelCharts

TRying to fit this to the plot of O BROTHER WHERE ART THOU...

Dr Ian McCormick@wokestudies.bsky.social · 7d ago

Handy Guide to the death count in The Odyssey. #Homer #epic #film #Nolan

Kind of intrigued as to where God fits on this

Simon Kuestenmacher@simongerman600.bsky.social · 7d ago

You can't argue with data as this magical white beard chart clearly demonstrates! The longer the beard, the more magical powers you possess. Source: buff.ly/2Gu510q

In SQL window/with functions a useful line is ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW. A vivd mnemonic for this is "Rowing between unbound princesses and chained rhinos"

In SQL window/with functions a useful line is ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW. A vivd mnemonic for this is "Rowing between unbound princesses and chained rhinos"

Passed my #PowerBI PL-300 renewal again. Massive anxiety everytime. I'm sure I still got all the stuff wrong I spent the day revising, but it's a good way of learning the new features and re-learning the things I don't use typically. I'll settle for 84%.

I know this is probably a bad time to post, but I made this interactive Region / Quadrant chart with #SVG in #PowerBI and I'm feeling like I want to show everyone. It's not a patch on @merrykerry.bsky.social's stuff, but I think it's the best one I've done so far.

From a #DataViz point of view, I really like the use of black here rather than red. It sends a very different message, which feels critical in the present moment. Also a great example of how our colour choices are not received as arbitrary. Colours carry deep routed, emotive associations.

wisevis@wisevis.eu · last mo.

A heatwave just for us? Ain't that sweet! 🥰🥰🥰

I know this is probably a bad time to post, but I made this interactive Region / Quadrant chart with #SVG in #PowerBI and I'm feeling like I want to show everyone. It's not a patch on @merrykerry.bsky.social's stuff, but I think it's the best one I've done so far.

I've spent the last two months putting together this exhaustive analysis of the New York Times coverage of trans people. It covers 3,242 articles over 12 years. In 2022, the NYT shifted towards a hostile stance towards trans people in their framing. www.thedissident.news/exclusive-ho...

Exclusive: How The New York Times Changed Its Coverage of Trans People

An exhaustive analysis of over 3,242 articles by the New York Times covering transgender issues from 2014-2026 revealed a stark shift towards hostile framing in 2022. In January 2015, the New York Ti...

thedissident.news

Yes, I'm up at 6:45 on Father's Day to practise my SQL before the kids wake up. That's normal, isn't it?

It's been ages since I posted anything on my blog, and quite a while since I posted something constructive on here, so... ...here's what to do if you're befuddled by trying to work out where the dataset connected to your Excel spreadsheet is coming from: charitydatageek.blogspot.com/2026/06/how-...

How to find which Power BI source Excel is connected to.

charitydatageek.blogspot.com

Having one of those days where I wonder if it might be quicker long term and short term just to copy and paste figures into spreadsheet rather than properly pulling the data from the databases, processing in PowerQuery, then doing the DAX etc. #MyHeadHurts

Microsoft not being joined up again: SharePoint links now ridiculously long HYPERLINK() function only copes with 255 character length URLs.

In #Excel I finally got round to using #AHK to remove merging & centre across selection instead. Here's the code (v2): #HotIf WinActive("ahk_exe EXCEL.EXE") +#c:: { xl := ComObjActive("Excel.Application") sel := xl.Selection sel.Unmerge() sel.HorizontalAlignment := 7 } #HotIf

Congratulations to the @unpivotshow.bsky.social crew on 50 episodes. I have learnt so much from them. I think @wynhopkins.bsky.social is the only one who's active here, but thanks to all 4 of them.

Unpivot@unpivotshow.bsky.social · 4mo ago

A slight divergence between title and image - but if you can’t have a laugh when AI is going to kill us all and Microsoft are ripping Dataflows from our cold dead hands, when can you laugh? #PowerBI #Excel #Unpivot youtu.be/pHmHGGx4x2I?...

This is a quick way to track items getting dropped/lost in a process, when you're tracking the data in #Excel Create a new sheet, copy the formula below across all the relevant cells, set cell widths & heights, turn off gridlines and colour the fonts accordingly. =IF('Main'!A6="","",UNICHAR(9608))

Nail on the head

T. from Data Rocks@datarocksnz.bsky.social · 3mo ago

bsky.app/profile/desi...

Genuinely struck by this. One of those things I always knew about on one level, and am quite surprised by on another.

Michael Friendly@datavisfriendly.bsky.social · 4mo ago

📊Ordering of variables in such displays is a design choice, and not surprising that you get different configs in radar plots. It is a good example of what I call Effect Ordering for Data Displays www.datavis.ca/papers/effec...

Taps the sign again

T. from Data Rocks@datarocksnz.bsky.social · 6mo ago

Often I think we should all just try to make "Slow down! Fix things!" the next big motto.

The #D365 click tax from having to close #CoPilot every time I open a new window (or refresh an old one) is just too much . Someone, please, make it go away. I know it's there (and everywhere else) if I need it.

Wouldn't it be cool to invest trillions of dollars into a technology that would actually make society better? Maybe we can call it “HI” — Human Intelligence. Instead of “data centers”, we could fund “schools”. Instead of *stealing* art, literature, and science, we help people *create* it. Crazy!

I hate the fact that daylight savings changes now means that I not only have to remember to turn the clocks back / forward. but I also now need to remember to update all my #PowerBI schedule refreshes.

I love this example of the limitations of user personnas.

T. from Data Rocks@datarocksnz.bsky.social · 4mo ago

And the comment about user personas made me remember of this classic.

Potential quick wins for #Excel development: Come up with some way of commenting out in the formula box. (I know there are work arounds but they're too confusing to the uninitiated)

Only just discovered this so apologies if everyone else knows about it, but in #Excel if you hover the mouse over the ribbon, you can use the scroll wheel to rapidly scroll through the tabs on the ribbon. Works in Word & PowerPoint as well but not #PowerBI

Can someone just confirm this for me, please? In a #PowerBI app, when you pressed "Go back" didn't it used to take us back to the workspace that app was from? Now we just go back to our home page, which (if true) is a step backwards IMO.

Time for the big debate... When you add new tabs in #Excel do you order them with most recent on the left, or the most recent on the right (so that you "start" at the left and work to the right)

The thing where adding a null to a value gives a null is a real weakness in #PowerQuery. How many people have missed this & not realised I wonder? Anyway, easy fix: use the coalesce function, or just put a ?? 0 after each column name that might contain a null. See www.youtube.com/watch?v=-FQr...

Power Query Secrets: Use coalesce (??) to handle null values

YouTube video by Excel Off The Grid

youtube.com