How to... get a bit more advanced with showing/hiding columns in a Table visual


How to ... get a bit more advanced with letting your audience customize a Table visual.

Hey there Reader,

Last week's post was about a cool little trick that allows your report audience to choose what columns they want to see in a Table (which makes a large wide Table WAY more user-friendly)...

THIS week we're learning how to get a bit more advanced with this show/hide trick, by grouping our columns using a fun little DAX function.

How to get more Advanced with hiding/showing columns in a Table Visual.

A bit more Joe: Celebrating Summer

If you've been subscribed to these emails for a bit, you know that I usually don't stick personal stories / photos in these emails.

My general philosophy is that you're here for the HOW TO lessons... I'm just a bonus. haha.

But, I will include a photo / story every now and again, so you know that I'm a normal fun person who isn't ALL about Power BI (how boring would that be?)


Living in Toronto, we have to embrace summer while we can, as it passes FAR too quickly.

Teenagers are notorious sleepers, so when I can talk mine into getting up before dawn to get a shot like this, it's a great success.

Hope you are also celebrating summer, wherever you are (but especially if you are somewhere that gets nasty winters.)

Not loving How To Use Power BI in your inbox anymore? Unsubscribe here.

(because you should only get these emails if you love them and find them useful!)

This Week:


Recent Posts:

How to hide/show columns in a Table visual

(read/watch this one first)

Use MAX in your DAX

All the way to the top, yeah!

Post Series: Line Charts

How to make, and format and do other stuff with Line Charts!


Check out our How-To Subject collections

Bar Charts

Making, formatting, fixing, even adding benchmark lines to bar charts.

DAX

Making, formatting, fixing, even adding benchmark lines to bar charts.

Hot (& Fresh) Tips!

Making, formatting, fixing, even adding benchmark lines to bar charts.

Take care everyone,

Joe.

You can learn from me in a workshop

I run friendly and informative Beginner and Advanced Power BI workshops. Get started (or level up if you already know the basics) so you can start reporting insights from your data ASAP! Hit the reply button on this email and let's chat.

You can pick my Power BI Brain

After 7+ years of using Power BI daily, I've come across (and sworn at) a LOT of error messages, things that don't make sense, and other challenges. You don't have to go through it all too... you can get me to help you through the challenges. Don't spend hours/days/weeks being frustrated... I've already gone through that FOR you. Talk to me. I can help.

TraversData.com | LinkedIn | Instagram



Silly Spreadsheet Merch

Hey, I also spend a lot of time in spreadsheets (don't we all) and had a fun idea for little stickers and magnets and shirts....

In Deep Sheet (Mug)

(Get into more deep sheet on other stuff too.)

Subscribe to Joe Travers