Joe Travers

How to SWITCH values in your Power BI DAX Hey there Reader,This week we're learning the SWITCH DAX function, which does just what you think it does... it *switches* a value (or text, or whatever) with another value (or text, or whatever).It's often used like a Nested IF statement, but it's wayyy easier to write and understand. How to SWITCH values with DAX. 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...

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...

How to show/hide columns in a Table visual! Hey there Reader,Wouldn't it be great if, when you have to use a Table visual in a report, you could let your viewers choose what columns they want to see? That way, a table with tons of columns can be shrunk down to just the columns different viewers actually need!Well, this IS possible, and Power BI forums have lots of complicated ways to accomplish it... but you shouldn't have to spend forever just to hide (or show) some columns.I'm showing you...

How to get started with Power Query Hey there Reader,One big advantage that Power BI has over some (not all) other data dashboard platforms is that it has Power Query editor built into it and allows you to clean, transform, and do just about whatever you need to structure your data just so for visuals and dashboards.Power Query activities can be basic, like removing columns or rows you don't need or renaming columns to more advanced like unpivoting columns, renaming columns in bulk, or just...

How to calculate a maximum value in Power BI Hey there Reader,This week on How To Use Power BI, we're having a quick look at the MAX function. It does exactly what it says on the box... it calculates the maximum value in a numeric column.This post also explores how the MAX calculation interacts with other visuals and charts that may be on your report page, but also how you can make it NOT interact with them (because sometimes that's what you need). That involves the ALL and CALCULATE...

How to do everything with Line Charts! Hey there Reader,Today I'm introducing a new post that compiles all our Line Chart posts (so far). I'll keep adding to it as new posts about how to do different things in Line Charts are added. Line Charts are easy to make, and are AMAZING at showing trends over time, but they can be misused really easily (ever seen a line chart that looks like a mess of spaghetti?)Currently, our Line Chart Post Series post has:How to make a Line Chart How to format a...

How to fix data label placement on Line Charts Hey there Reader,Power BI is 10 years old this summer, and yet it still fails on some basic data visualization things, like where to place labels on data points (yes, really... I wish I was joking).Learn more about it, and how to FIX it, here. Not loving How To Use Power BI in your inbox anymore? No problem. Unsubscribe here. (because you should only get these emails if you love them and find them useful!) This Week: Why value labels can fail on...