Joe Travers

How to custom color value labels on a Pie Chart Hi Reader,I'm currently on the west coast visiting my brother (he's near Vancouver BC... beautiful!) but you still get a How To post from me. This time it's about how to color your pie chart value labels so they are the same color as your pie slices. Power BI doesn't make it straightforward, so you kind of have to poke around under the hood to find out where the option is to make it happen.How to custom color value labels on a Pie Chart: Not...

How To Use the DAX Format function Hiya Reader,This week's How To post is an introduction to the FORMAT function in DAX. We can do a LOT of cool stuff with this function with different types of data (text, numbers, even dates), but I'll get you started with an easy one.The DAX FORMAT Function. 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!) Need More DAX? I got you. :) All the DAX posts...

How to ... Hey there Reader,This week's post is all about one of the most common data cleaning activities that has to be done in Power BI using Power Query Editor... getting your column names to actually BE your column names. Sometimes, when you connect to data like an Excel sheet, Power BI can't read the column names in your Excel sheet properly (it's not your fault, it's Power BI's) so you have to help it out a little bit...How To... get your data column names to show up properly in Power...

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