Winston Snyder

Loves the Cowboys, SunDevils, Pizza, Excel BI, Power BI, Power Query, SQL

[Jon Schwabish @jschwabish]

This may be the strangest y-axis I have ever seen. | https://t.co/gVhlHZQtE8.

[Winston Snyder @dataprose]

#excel | #customnumberformats

I was today years old when I learned you could use an index number inside a custom number format string in Excel. See Color48 below to return a gray zero.

_(* #,##0_);_(* (#,##0);[Color48]_(* "-"_);_(@_)

#microsoft #micros…https://t.co/E8Imr2mywW

[Winston Snyder @dataprose]

@PacktPublishing @_SoheilBakhshi Email back and forth support. Seems issue I came across a different branch/repo. See screenshot comparison.

[Winston Snyder @dataprose]

@PacktPublishing

Help me out here. Trying to submit Errata for Expert Data Modeling with Power BI - Second Edition. No result found

@_SoheilBakhshi

[Winston Snyder @dataprose]

@PacktPublishing @_SoheilBakhshi Thanks,
Submitted.
Maybe the files on the Github repo are not in sync with the book? I look forward to resolving this.

[Winston Snyder @dataprose]

@_SoheilBakhshi @PacktPublishing Thanks @_SoheilBakhshi.

BTW, the image quality in book is excessively poor. Having the color image available in the pdf helps. Still, consumer deserves better.

Please compare first denormalization image to color images.

[Winston Snyder @dataprose]

Excel Error Austria Vote

Interesting. When you pound a nail with a hammer and you accidentally miss and hit your thumb, who is to blame - the hammer or the user? Exact same thing in the case of this vote in Austria. Double-check y…https://t.co/EuHzxbmvQm https://t.co/JjgElZ7oOf

[Winston Snyder @dataprose]

Love this one today from ChartR/Storytelling

Note the broken y-axis between 0 and 1:45. This helps visualize the change in the average length of a baseball game.

What can MLB do to make it even faster? 1:54 minutes sounds good to me.

We dropped 2 of 3…https://t.co/OgemYO1bev

[Winston Snyder @dataprose]

Aging Population

Crazy this one from Visual Capitalist
By 2100, 25% of the world's population will be 65 years old or older. https://t.co/bfVAZ7wCkv

[Winston Snyder @dataprose]

#Fabric | #Powerbi

Is it just me, or does the color of the new #logo for #Fabric look the same color as rebranded #PowerBI desktop? #microsoft https://t.co/ZCTcP3r2HP

[Winston Snyder @dataprose]

Excel | Toolbar

Two kinds of Excel people in this world. New Toolbar View or Classic View. Which are you?

I'm using Beta Channel version of Excel so you may not have features if you are on another channel.

#microsoft #office365 #excel https://t.co/3GRITOh9Ns

[Winston Snyder @dataprose]

@GoogleSupports2 2-step verification does not work after fully updating Windows 11 yesterday. Tried Firefox, Edge, Chrome browsers.

[Winston Snyder @dataprose]

Power BI | Subtitles

Power BI Desktop now supports Subtitles with March 2023 release.
Lot's more goodness to unpack. Great job Power BI Team!

#microsoft #powerbi https://t.co/KPAoR2b9D6

[Winston Snyder @dataprose]

@GoogleSupports2 I cannot log into Google after running Windows 11 updates yesterday.

[Winston Snyder @dataprose]

Excel | Slicers | Search

Nice trick here from Jon Acampora at Excel Campus how to "add" search to your Slicers in Excel.

Link in the comments.

#microsoft #excel #slicer https://t.co/9Ku1MYw1B6

[Winston Snyder @dataprose]

Test – please ignore.
But if you don’t want to, I created the bold text by creating in Word, applying formatting, copy/paste to LinkedIn.

#linkedin #lackofformattingoptions

[Winston Snyder @dataprose]

Power BI | DAX | Time Intelligence
I know how he feels. I was was working with STARTOFQUARTER() yesterday

#microsoft #powerbi #dax #timeintelligence https://t.co/9PXlC8RjbH

[Winston Snyder @dataprose]

Power BI | Data View

It would be helpful if we could Filter on Selected Item as we can in Excel

#microsoft #powerbi

[Winston Snyder @dataprose]

I don't like the new Microsoft 365 App logo.
Put me down for a no.

#microsoft #office365 #microsoft365 https://t.co/TGwvl56xhP

[Winston Snyder @dataprose]

Power Query | Power BI | Excel

When you add a random number to a Custom Column in Power Query using Number.Rand() or Number.Randbetween, you have to add an Index Column before and after the Rand Column. Why is that?

#microsoft #powerquery #excel #powerb https://t.co/LJiCXcm6ac