Today I'm trying to work out how I can best serve up the data experience I want given the strengths, constraints of the tool. I'll live tweet thoughts as I go.
![](https://pbs.twimg.com/media/EVWzP45UcAU4jX3.jpg)
Newsroom:
Ministry of Health:
ESR:
Stuff (yet to do more critique):
health.govt.nz/our-work/disea…
![](https://pbs.twimg.com/media/EVW4IMpVAAADSPC.png)
![](https://pbs.twimg.com/media/EVW6gqMUwAcCfI2.png)
![](https://pbs.twimg.com/media/EVW9rWtU4AAwUtw.png)
![](https://pbs.twimg.com/media/EVXDiQaU4AA786t.png)
I tried to add an idea for this, but I can't lodge ideas any more. ideas.powerbi.com/forums/265200-…
*Comparison to Australia
*Ethnicity/Age breakdown, weighted by demographic popn
*Map of incidence by DHB with spikes (probably thin bars) rather than bubbles.
*Small multiples allowing comparison between regional trends
* Whatever else U want to see
Please give us better access to better data @minhealthnz
health.govt.nz/our-work/disea…
![](https://pbs.twimg.com/media/EVXidm9UUAAch_x.png)
health.govt.nz/our-work/disea…
![](https://pbs.twimg.com/media/EVYD4_qU8AEx52e.png)
case-list-12-april-2020-for-web.xlsx
Another fail. C'mon!
![](https://pbs.twimg.com/media/EVYf-GLUwAg7y6O.png)
I've added in NZ Census figures on the right that show 15% variation for Auckland. This affects per capital testing figures. What am I missing?
health.govt.nz/our-work/disea…
![](https://pbs.twimg.com/media/EVYn5BaUMAAEiDb.png)
MOH main page says 15 new in 24 hours to 8.30 am, 13 April
MOH Case Details page says 18 cases on 12 April, and 1 on 13 April.
Press conf at 3:25pm 13 April says 19 cases.
...and just don't show the latest day, as there is often just a few entries as at the time they upload it.
But then folk will say "Your numbers don't match reported ones"
*Sigh*
Do you think they should? Should they crosstab too? I'm not sure...still mulling it over.
![](https://pbs.twimg.com/media/EVeMeiVUMAMkOW9.png)
(I will in my dashboard)
![](https://pbs.twimg.com/media/EVeOBnSUUAATTPr.jpg)
@ChiefSciAdvisor any assistance appr
![](https://pbs.twimg.com/media/EVeQgNRUMAAGUiz.jpg)
...but at the DHB level they just show the last data point. I think they should publish time series by DHB that ultimately includes data on false pos & neg. You?
![](https://pbs.twimg.com/media/EVgcMBWUUAIpeOS.png)
![](https://pbs.twimg.com/media/EVgc_yWU4AAUY_T.png)
There are a LOT of different requests for this over at the Ideas site. e.g:
ideas.powerbi.com/forums/265200-…
![](https://pbs.twimg.com/media/EVhu2XWUEAE0mHo.jpg)
I believe @minhealthnz just uploaded the new figures for NZ, so here's the update. I probably should supress the last day, as it's not a complete day...it was the numbers as at 9am.
![](https://pbs.twimg.com/media/EViB8phVAAE_kXB.jpg)
The image below shows that @minhealthnz aren't even giving web tables unique names. So again I'll have to manually cut and paste from their webpage. Again, a fail in the age of open data.
@ChiefSciAdvisor
![](https://pbs.twimg.com/media/EViFyWNU8AMHTVF.png)
![](https://pbs.twimg.com/media/EVikyngU0AAqMMC.jpg)
C'mon @minhealthnz - do I REALLY have to get my ruler out or go through previous press releases to get a figure that should be available in a Table or by CSV?
![](https://pbs.twimg.com/media/EVnIrNVU0AAeThk.jpg)
But I'm NOT going to put a comma in that number format. No way. We won't be needing it. Not if you #StayHomeNZ
![](https://pbs.twimg.com/media/EVnSSyiUwAIEHTW.png)
And also note that this isn't a longitudinal study :-)
I've also put Y axis on RHS, closer to where the action is. HT @TheSpinoffTV
Colours are placeholders. Need #Datafam advice!
![](https://pbs.twimg.com/media/EVn1qb9U0AAyNoR.png)
![](https://pbs.twimg.com/media/EVn3NbhUUAAd-L0.jpg)
Go. Vote.
ideas.powerbi.com/forums/265200-…
It's a valid argument. I just don't care for it :-)
![](https://pbs.twimg.com/media/EVq3Ob9UEAEzRZd.png)
Good idea. I think it works. I need some #Tableau #Datafam person to tell me what colours to use tho...us #PowerBI folk are "colour challenged" 🎨
![](https://pbs.twimg.com/media/EVsbsljVcAAZQal.jpg)
![](https://pbs.twimg.com/media/EVySwtbVAAEU45x.jpg)
![](https://pbs.twimg.com/media/EV9XpwzUEAE7-5-.jpg)
dataveld.com/2018/01/02/fon…
![](https://pbs.twimg.com/media/EV_ey4jUwAEgcyz.jpg)
Also added deaths by cluster. Mission.
![](https://pbs.twimg.com/media/EWFoCVlUEAofcA-.jpg)
![](https://pbs.twimg.com/media/EWPylrYUYAIu9CM.png)
I'm not 100% happy with the grey background, but it helps the DataBars stand out more in conjunction with white gridlines.
![](https://pbs.twimg.com/media/EWZYdl0UcAEDQo_.jpg)
![](https://pbs.twimg.com/media/EWZasVcUcAAM13o.jpg)
![](https://pbs.twimg.com/media/EWZ7YatU4AQvs_L.png)
![](https://pbs.twimg.com/media/EWaHA7yVcAQ2gIH.jpg)
![](https://pbs.twimg.com/media/EWaJeXYVcAAeBQh.jpg)
![](https://pbs.twimg.com/media/EWaKSCYUcAAZs-G.jpg)
![](https://pbs.twimg.com/media/EWaPf1HU8AAfv4n.jpg)
![](https://pbs.twimg.com/media/EWaSUaVVcAEZQ6J.jpg)
![](https://pbs.twimg.com/media/EWexG1SVcAA0kw2.png)
![](https://pbs.twimg.com/media/EXFs2tgUwAAQjtv.jpg)
I find colours hard in any tool, but especially loathe the colour picker in Power BI.
You?
(Dark grey shows totals before @minhealthnz started breaking down further by active/recovered on 16 April)
![](https://pbs.twimg.com/media/EXPmUqFU0AY-u9i.png)
Will add toggle to show this or just simple numbers.
![](https://pbs.twimg.com/media/EXVB45-VcAAS9fl.jpg)
Warning: Performant at *loading*, it ain't.
Performant at *insight-ing*, it is.
![](https://pbs.twimg.com/media/EXm9T5QU0AAARre.jpg)
Vote for measure-driven datalabels here: ideas.powerbi.com/forums/265200-…
![](https://pbs.twimg.com/media/EXnC2CXU0AAeJtL.jpg)
(Some of course wouldn't...and I expect to hear from Mr @lapajne shortly 😂)
![](https://pbs.twimg.com/media/EXnFN55UMAYekRO.jpg)
![](https://pbs.twimg.com/media/EXph5BgUwAAG28x.png)
![](https://pbs.twimg.com/media/EXpiH7jVAAAHitP.png)
Not many people know you can do a 100% stacked databar in #PowerBI like I'm doing here....including @Will_MI77 😂
![](https://pbs.twimg.com/media/EX7iL-iUYAIwLjV.png)