Nice dashboard. What does it actually tell you?


We all want dashboards that look professional.

But a dashboard that looks good and doesn't tell you much? That's more decoration.

Your manager sees $2.3M in revenue displayed front and center.

Okay. Now what? Is that good or bad? Better than last year? Did we hit target?

Without context, that number means nothing.

Power BI's new card visual (now generally available) lets you add that context right into your KPIs. Previous period comparisons. Target indicators.

Professional design with meaningful insights. Plus, it's quite satisfying to create.

​See for yourself.

video preview​

Way more flexible than the old card visual. And way easier than building custom layouts from scratch.

Lots of room to get creative.

Let's connect at Global Excel Summit

Microsoft releases dozens of updates every year. Some very useful. Some not.

The hardest part is finding out about the useful ones before you continue doing things the hard way for months.

That's why I always look forward to the Global Excel Summit in London. You get to talk to people who've already tested this stuff. What works? What's overhyped?

Two days of sessions across Excel, Power BI, Python, Power Automate, and AI. But honestly, the best conversations happen between sessions.

I'll be there in May. Would be great to see you there too.

πŸ—“οΈ 19-20 May 2026 (conference)

πŸ—“οΈ Optional masterclasses: 18, 20, 21 May

πŸ“ London, UK

Last few Early Bird tickets available.

Use code LEILA at checkout for an extra 20% off.

(The discount box shows up at the last step. Click "Continue to Checkout" twice, then enter LEILA in the Order Summary.)

πŸ€“ Geeky News

πŸ—’οΈ Notepad gets tables

Windows 11's Notepad now supports tables (currently available to Windows Insiders).

Click the Table button in the formatting toolbar, pick your rows and columns, and you're done.

You can add or remove rows and columns with a right-click.

The once basic text editor has been adding more formatting options, like bold, italic, bullet points, since the beginning of the year. The good news is that it remains fairly lightweight.

BTW, if you're using Notepad++ (a more powerful editor popular among developers), make sure you update to the latest version to fix a security bug.

πŸ’¬ Word comments get a refresh

Word for the web just updated its commenting interface. Cleaner design. New icons and buttons. Better layout.

The useful part? Selected comments are highlighted while the rest fade to gray. Makes it easier to focus on the feedback you're dealing with.

This got me thinking: Comments work across Word, Excel, and PowerPoint. The experience is similar but not identical. Each app develops them separately. So you get features in one that don't show up in the others. A bit frustrating when they could just keep them in sync.

πŸ’š Why We Can’t Quit Excel

Bloomberg just published a feature on Excel's history, its dominance today, and where it might be heading.

I got to contribute a few quotes alongside other Excel experts and the people who built the app.

I talked about my relationship with Excel. When I first started working, it was definitely not a tool I'd open and think "Oh my God, I love this."

But the more I learned what it could actually do, the more I appreciated it. That's how it works with most tools. You stop fighting the shortcomings and start seeing what's possible.

And Excel is just always there. In every finance department, every business, every laptop. It's part of how we work. Forty years in.

Read the full article here (Bloomberg subscription required).

πŸ™Œ Building What the Team Actually Needs

Congrats to Anton on completing Fast Track to Power BI 🎊

Here's what changed: he stopped building dashboards to show off cool features. Started building them to answer specific questions.

Anton Meriaux,
Clinical Data Manager

My first takeaway from this course is about all the features available - such an eye-opener.

The second takeaway is about storytelling and knowing your audience.

Don't implement all kinds of fancy visuals just because I can, but figure out what kind of questions my audience will have and how I, in a simple and clear way, can answer these questions through my visuals.

With Power BI, I now have the skills to set up more study-specific dashboards, which surely will benefit the whole project team and speed up our work in finding anomalies or dependencies that are not easily spotted reviewing long data listings.

His whole project team can now spot issues they'd never catch in raw data.

Think about your own dashboards. Are they answering questions or just displaying data?

See you next week,

Leila

Want more?

▢️ Subscribe on YouTube​

πŸ–‡οΈ Follow us on LinkedIn​

πŸ₯‡ Join 400,000+ students in our courses​

πŸ“£ Want to sponsor Between the Sheets? Get in touch here.

πŸ“¨ If you were forwarded this message, you can get the free weekly email here.

This newsletter contains affiliate links, which give us a small commission on any purchase made at no cost to you. This helps us run Between the Sheets and bring you updates like this. Thank you for your support!

Leila Gharani - XelPlus

XelPlus is a leading online education company, providing training courses for Excel, Power BI, Finance, and Google Sheets. XelPlus’ bestselling courses are popular among financial analysts, CFO’s, and business owners. Technology is changing fast. We help our members turn confusion into confidence with every skill learnt.

Read more from Leila Gharani - XelPlus

You import a CSV in Power Query... Dates have errors. Numbers won't calculate. What just happened? Here's what's usually happening. Your computer is reading the file with your regional settings. So if your CSV uses commas as decimal separators (like 1,5) but your system expects dots (like 1.5), Power Query gets confused. Same with dates. Is 04/05/2025 April 5th or May 4th? Depends on where you are. The fix: Change Type Using Locale. But here's the part that trips people up - order matters....

Let's say you're waiting for colleagues to submit the latest data. You need to check if the files came in. And if the data is complete. So you start opening files one by one. It's tedious. And completely avoidable. When Microsoft released the new IMPORTCSV function, I wasn't ready to throw Power Query out the window. It still handles far more sources and does things this new function simply can't. But it got me thinking. What if you could peek at a CSV without fully loading it? Just enough to...

Excel's chart formatting menu is dangerous. Not because it's bad. Because it gives you too many options. And some of them have no place in a professional report. Take this social media trend: pasting images directly into your chart bars. Looks creative. Gets lots of views on YouTube. But would you put that in front of your manager? In just a few extra clicks, the same data can look like this: Same logos. Matching brand colors. Just used with intention. πŸ‘‰ Watch: How to build this chart in just...