The Big Beautiful Bar Chart: Build It in Tableau with Map Layers

11:07

The Big Beautiful Bar Chart: Build It in Tableau with Map Layers

Andy Kriebel 25.05.2026 864 просмотров 34 лайков

Machine-readable: Markdown · JSON API · Site index

Смотреть на YouTube

Поделиться Telegram VK Бот

Транскрипт Скачать .md

Анализ с AI

Описание видео

In this video, I show you how to build what I call the Big Beautiful Bar Chart in Tableau. It combines colored bars, a budget reference line, donut charts, and clean labels all in one view using Map Layers. It looks stunning and it tells a complete story. Here's what you'll learn: - How Map Layers work and why they unlock chart types Tableau can't build any other way - How to set up your data with a five-point scaffold to draw filled rectangles as bars - How to use LOD expressions instead of table calculations (and why it matters for Map Layers) - How to add a dotted budget line, sales labels, region labels, and a percentage label as separate layers - How to control mark interactivity, opacity, and alignment across multiple layers By the end, you'll have a chart that looks like it took hours but follows a repeatable process you can apply to any dataset. If you can build this, you're already operating at a high level. Next Level Tableau is where analysts like you go to push further, work alongside the best in the datafam, and get direct access to live training with me every week. Join us at nextleveltableau.com Timestamps: 00:00 What we're building 00:27 How Map Layers work 01:00 Setting up your data 01:45 Percent of total with LOD 02:20 Building the bar calculation 04:37 Adding color and sorting 06:19 Adding sales and region labels 08:00 Adding the percentage label 08:54 Building the budget line 10:36 Adding the pie chart layer 10:46 Wrap up #Tableau #MapLayers #DataVisualization #TableauTips #DataViz #Datafam #TableauCommunity #MakeoverMonday #WorkoutWednesday #NextLevelTableau ---------- To go deeper, check out my courses: → Tableau Starter Kit - A beginner-friendly course designed to help you understand Tableau quickly - https://www.nextleveltableau.com/starterkit → Tableau Core Concepts - A comprehensive, self-paced course for Tableau users ready to level up - https://www.nextleveltableau.com/tcc → Join Next-Level Tableau - My most comprehensive Tableau program to help analysts become industry leaders, with the support of a like-minded community, and 1-to-1 help from me - https://www.nextleveltableau.com/ 📩 The Dual Axis Newletter Each week, I'll send you Tableau tips, tutorials, and strategies to design better dashboards, have more impactful, and stand out in your career: https://nlt.kit.com/ 🔽 Connect With Me • Official website - https://www.nextleveltableau.com/ • LinkedIn - / andykriebel #tableau #dashboard #tutorial #beginner

Оглавление (11 сегментов)

What we're building

In this video, I'm going to show you how to build this big, beautiful bar chart. We'll build this with map layers, but first, let me explain to you how it works. Now, with map layers, all you have to do is picture the Earth being flat. And notice how the latitude goes from minus 90 to 90, and the longitude goes from minus 180 to 180. Well, as long as you can fit your data in that range, then you can build anything in Tableau. And

How Map Layers work

here's how it works. To draw the simple bar chart, we're going to start at the bottom left, which is the latitude longitude of zero and zero. Then we go up 1° in latitude, over to the right to our percent of total, down and then back across to zero zero. So, you have to have five points to close off the entire rectangle. — And then we go ahead and create a point to shift the pie chart over to the left, and we're done. So, let's see how we build it. We need two things. One is our data set. In my case, I've got sales and

Setting up your data

budget. And we need a second data set that gives us the points so we can connect the marks in the map layers. So, in this case, I'm only going to use five points because my rectangle requires five points around the edge. So, back in Tableau, I'm going to go ahead and drag in my sales and budget data, and I'm going to drag in my five points. Bring over my sheet one from my five points data set, and then need to build a calculated relationship. Click on the relationship noodle, and in the bottom, go ahead and choose create relationship calculation, and I'm just going to set it to one on the left. Create another relationship calculation on the right, and let's call that one as well. Hit okay. And there we go. That's all of our data prep done. Now, we need to do a couple

Percent of total with LOD

of things. First, we need to create a calculated field for the percent of total sales. Our percent of total sales is going to be our sum of sales divided by the sum of our grand total sales. And I'm going to do that with a level of detail expression. I'm going to start with the mustache show and then it's just the sum of sales. Now, the reason I need to do this with a level of detail expression is because I can't use map layers with a table calculation. Hit okay and while I'm here, I'll go ahead and set the default number format to be a percentage to zero decimals.

Building the bar calculation

Click and okay. If I go back over to our big beautiful bar, notice I also have this dotted line down here on the right-hand side that represents our budget. So, I'm going to duplicate my percent of total sales calculation and swap it out for the budget. Edit the copy. We'll call this percent of total budget. And I'm going to replace sales with budget on both sides of the calculation. And that's it. Everything else is ready to go. Now, we need to use a case statement to create our bar chart calculation. Let's create a new calculated field. And I'm going to call this my bars. I need to use a make point calculation because those going to create the individual dots I need to connect. And I'm just going to give myself a bit of space and I need to start with my latitude. Going to go my case statement and I'm going to evaluate each point ID. So, if I go back over here, we have one point down here. So, this is our zero latitude. Latitude of one. Latitude of one on the right, back down to zero, and then zero again. Okay, so that's everything we need there. So, I'm going to say when my point ID is one, then my latitude is zero. When I'm on my second point, then my latitude is one. When I'm on my third point, then my latitude is still one. Then I come down on point four, back to zero. And then I'm going to close it off and stay back at zero at point five. And end. Okay, so that's my latitude. Now, let's do our longitude. I'm just going to copy this statement and I'll paste it down here. And this time I want to start at 0 0. On my longitude when I go to the next point, I'm going to stay at longitude of 0. So, point two is going to be 0. Point three my percent of total sales. Point four will still And point five goes back to zero. Now, I get an error message that I can't mix aggregate and non-aggregate. That's because my percent of total sales is an aggregate. I'm just going to wrap my point ID in a min. And do that in both the longitude and the latitude. And there we go. We get a valid calculation. Drag that onto the view and you get a single point. Let's go

Adding color and sorting

ahead and change the mark type to a polygon. And let's drag point ID onto the path. And you see now Tableau has drawn a square. That's okay. We're going to go ahead and drag region to the rows to split it up. And notice now we have different length bars. Great. Now, we can't turn off the map background yet to make these bars the right size. We first have to create a second layer. I'm going to drag region till the color shelf as well and I'll leave it like that for I'm going to click on color and maybe I'll just reduce the opacity a bit. In my final version I've used custom NLT colors. If I look over at my final solution, I have this L-shaped bar around the edge. Okay, I'm going to go ahead and duplicate this bars calculation. — [clears throat] — And I'm going to edit the copy. call this my L bars. And this is the same exact thing except I'm only going three points. I'm not connecting the dots all the way around. So, I'm just going to remove points four and five. Click on okay and when I drag that on, I have to make sure I drag it as a marks layer. Change the mark type to a line and drag point ID to the path. And I'll drag region onto color. And there you go. Now you can see we have that nice L-shaped bar. Now, because we have two layers, we can turn off our background maps. So, go up to map on the menu, background maps, and set it to none. Okay, there we go. And I'll change the view to entire view. And while I'm here, why don't I go ahead and sort the regions by sales. I'm going to change my sort by to a field, descending order by sales. Great. Okay, let's move on to our next point.

Adding sales and region labels

We're going to go ahead and create another calculated field. This one is our sales label. We're going to use the make point function, and we want this to be on the bottom left. So, that's just going to be 0 0. Click on okay, and drag that on as a layer. Go ahead and change the mark type to a circle. I'm going to drag region onto color. And sales onto the label shelf. And I'll go ahead and change my alignment to the upper right. And I'll set the font to something bigger, maybe 15 point. And click on bold. Okay, so that's our sales. Now, we want to put the region label on the upper left of the bar. Okay, let's do the same thing. Let's create a new calculated field. Let's call this our region label. And we're going to use the make point function again. This time, our latitude is going to be one, and our longitude is zero. Click on okay, and let's drag that on as another layer. We're going to make this one a circle as well. And I'm making them circle because it makes it easier to control the alignment of the mark. I'm going to set my label to be on the right and at the top. And let's go ahead and drag region onto the label. format that and make it maybe 15 and bold again, similar. There we go. Now, we don't have enough space yet, but we'll take care of that in a minute. I don't want to see that point though, so I'm going to click on the color shelf and drag the opacity down to zero. And I don't want my users to be able to click on these marks. So, in my marks card, I'm going to choose disable selections for all of the levels that I don't want people to be able to click. So, my L-shaped bars, I'm going to

Adding the percentage label

disable. Actually, I'm going to disable everything. Okay, so now when they click, nothing happens. All right, now we need another point that is going to give us our percentage out on the upper right. So, let's call this our uh percentage label. And we're going to use make point again. This time our latitude will be one and our longitude will be the percent of total sales. Click on okay and let's drag that on again as a layer. We're going to change it to a circle. I'm going to drag region to color to match the bar. And I'll put percent of total sales on to the label. And on the label shelf, I'm going to go ahead and set it this time to the left and to the top. And I'll set it to bold and 15. Again, notice it doesn't fit. That's okay, we're going to take care of that. And I want to make sure I turn off being able to click on that.

Building the budget line

Great. Now, we want to create this budget line that goes down the right. Let's create another calculated field. And this will be our budget line. And we're going to use the make point function. We're going to do something similar, but this time we only need two points, the top and the bottom of the line. So, I want to evaluate my point ID. When I'm point one, then my latitude is going to be I want it to be slightly above the bar, so let's maybe make it uh 1. 1. When we're at two, then we want to go below the line, so let's make it minus 0. 1. And then end. And then my longitude, so let me just copy that. My longitude when I'm at one, this is going to be my percent of total budget. And when I'm at two, I'm going to be my percent of total budget as well. Okay, and again, I need to wrap my point IDs in an aggregation. Click on okay. And let's drag that on as a layer. We're going to change it to a line. Point ID to the path like we've been doing. And now I have the option to change the type of line. So, I'll make it maybe a dotted line. And I'm going to turn on my labels. I'm going to only label the ends of the line, so I want to label the end of the line. And let's grab budget and put that on to the label. Okay, and there we go. And again, I'm going to turn off the selection. Now, if you want to add the pie chart to the left of this, you're just going to

Adding the pie chart layer

continue to make different points. You'll create a point for the pie, and you'll use the same point again for the circle. And there you have it. You now know how to create a big, beautiful bar

Wrap up

chart. I hope you found this helpful, and if you did, please let me know in the comments what you liked best. What was the one moment that made a lot of sense to you? And if you want to take yourself farther, consider joining next level Tableau. It is the world's premier live Tableau training. You can get more information in the description. Have a good day.

Другие видео автора — Andy Kriebel

Ctrl+V

Экстракт Знаний в Telegram

Экстракты и дистилляты из лучших YouTube-каналов — сразу после публикации.

Подписаться

Лучшие методички за неделю — каждый понедельник