Joe Travers

How to build a Ring Donut chart in Power BI! Hey there Reader, Last week, our post was about the new border and transparency options in Pie and Donut charts and specifically why they are NOT good features for Microsoft to add if we care about accessibility and usefulness...This week however, I'm showing you ONE way borders can be kinda useful in a Donut Chart... to make a kind of Donut chart I'm calling a Ring Donut chart. You can see it to the right of this paragraph. Just this one way for...

How to NOT use new transparency and border options in Pie & Donut Charts Don't do this Reader, This week's post on How To Use Power BI is a bit different than usual. A couple weeks ago I recorded a video that talked about the new Transparency and Border options that have been added to Pie & Donut Chart formatting, and why, most of the time, you should NOT be using them.Microsoft sometimes adds things to Power BI (and a lot of Power BI people get way too excited about them) that don't actually...

How to search (and find) formatting options in Power BI I found you Reader! This week we're talking about a feature on the Power BI formatting pane that lets us search (yay!) for formatting options. We'll explore how it works most of the time, but also when it doesn't work at all. *cue the womp womp sad trombone* How to search formatting options in Power BI 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 ... Hi Reader,This week's post is all about splitting data columns using Power Query Editor. Sometimes your data source has information that would be more useful in 2 (or more) columns all smushed together into 1 column...While it's best to fix this in your actual data source, sometimes you don't have direct access to it, so you need to do it in Power BI itself, using Power Query Editor.It's nice and easy to do, if you need to!How to split data columns in Power BI using Power Query...

How to "Pie Chart" in Power BI Happy September Reader, This week we're posting a new Post Series post with links to all the posts about Pie Charts (so far). How to use (and NOT use) them, how to format them so they are most useful to your viewers, and how to color their value labels to match the slices.We'll be adding some more Pie Chart / Donut Chart (basically the same thing, with a hole in the middle) posts over the next few weeks... like how to use (and NOT use) new formatting options...

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