profile

Joe Travers

You CAN learn Power BI easily AND enjoy doing it! You can do it. I can help!

How to fix Power BI's new BAD Line Chart defaults

How to fix the new misleading default line chart swoopiness in Power BI. Hey there Reader,Microsoft tweaks how Power BI visuals appear every once in a while, and unfortunately they've been doing a lot of this recently... sadly moving chart and page defaults in the WRONG direction... away from better design for your viewers.Our next few posts on Power BI will be how to fix these new defaults (and in some cases, how to override them permanently!).We're starting with how to fix the new...

Size Matters in Power BI visuals (People-Friendly Power BI)

Why everything on your dashboard is too small. Size Matters Hey Reader, It's been a minute since our last People-Friendly Power BI post, but we're back with a post about why you NEED to pay attention to the size of everything on your Power BI reports... including the things that people click / tap on to interact with your data visuals.Learn about Target Size, and why ignoring it can make your dashboard unusable or even something a lawsuit can be about. Take care,Joe. Power BI Crash Course in...

How to standardize column widths in a Power BI table visual

How to make all those columns the same size! Hey there Reader,Power BI is over a decade old, yet the developer team only just got around to giving us the ability to make all the column widths the same in a table visual. People that design with Power BI have been asking for this functionality for just about as long as Power BI has existed.Let’s explore how to do it! Power BI Crash Course in Charlotte, NC On Nov. 17th, I'm going to hold my very popular Power BI Crash Course "Paradise by the...

Spring has sprung with Travers Data and Power BI

Hey Reader, It's been about 6 months since I last emailed you as a participant in one of my conference workshops on getting started with Power BI. It's FINALLY spring here in Toronto, and I'm feeling more alive than I have in months (I only like winter when skiing or skating). What's New? Power BI Beginner Workshop in Charlotte, NC (November 2026) I'm doing things a little differently this year with my workshop...Every year, I submit my workshop and then wait months (usually until summer) to...

How to do percentages in Power BI

How to do percentages with DAX code. Hey there Reader, This week we're going to be looking at the DIVIDE function in DAX. This is *mostly* used to figure out percentages of things (but you could also use it with some formatting to show ratios too.) Learn the DIVIDE function. Power BI Crash Course in Charlotte, NC On Nov. 17th, I'm going to hold my very popular Power BI Crash Course "Paradise by the Dashboard Light" in Charlotte, NC. I usually hold this at conferences, but this time I decided...

How to override all filters using DAX!

How to see ALL your data, with DAX Hey there Reader, Sometimes, when you're building something in Power BI, you may have filtered a visual or a page in a certain way... but THEN need to show a SUM, or a COUNT, or a PERCENTAGE that uses ALL your data, with no filters.Use DAX and the ALL function to unfilter data! You can totally SHARE this email with your friends / colleagues / neighbors / pets. Just click that forward button in your email program. Were you forwarded this email? Click here to...

How to code a Transparent Color in DAX

How to code color transparency into DAX. Hey there Reader,This week's post is a really cool one. For years and years, Power BI people have been trying to figure out how to make charts disappear in certain circumstances when they aren't needed (or you want to another chart in that space) ... and people have figured out ways (I've figured out a few myself).However, this way is by far the easiest. It needs just one simple line of DAX. No foolin'. How to code a Transparent color in DAX You can...