X and y graph12/22/2023 (Optional) Customize the font color, size, and display units for the two axes. Our secondary Y axis represents the line chart. In the Visualizations pane, select the paint brush icon to display the format options. The left axis measures sales dollars and the right axis measures gross margin percentage.īecause we started with a visualization with one formatted Y-axis, Power BI created the second Y-axis using the same settings. Power BI creates two Y axes, allowing the values to be scaled differently. Reformat the visualization to remove the angled X-axis labels. This type of visual supports a single line chart value and multiple stackable column values.ĭrag Sales > Gross Margin Last Year % from your Fields pane into the Line Values bucket. Select the column chart, and change it to a Line and stacked column chart. Before we can format dual Y axes, we'll create a combo chart that compares trends for sales and gross margin. Some visualizations can benefit from having two Y axes. Let's make the gridlines stand out by changing the color and increasing the stroke:Įxpand The Gridlines Tab: Select HorizontalĪfter all these customizations, your column chart should look something like this:Ĭustomizing visualizations with dual Y axes We'll add Y-axis titles to a dual-axis visual later in this tutorial. For this visualization, having a Y-Axis title doesn't improve the visual, so leave Title turned Off. When the Y-axis title is On, the Y-axis title displays next to the Y-axis labels. One reason you might want to turn off the Y-axis, is to save space for more data. Right now, they're light grey, small, and difficult to read. The Y-axis labels are displayed to the left by default. Let's make a few changes to get you familiar with the options, and then you can explore the rest on your own. The following example continues our customization of a column chart. And, for categories, you can modify the width, size, and padding of bars, columns, lines, and areas. For values, you can modify the display units, decimal places, starting point, and end point. You can add and modify the data labels, Y-axis title, and gridlines. There are many features that can be customized for the Y-axis. If you ever need to revert all of the changes, select Revert to default at the bottom of the X-Axis customization pane. Save the changes you've made and move to the next section. In this case, it's FiscalMonth.įormat the title text color, size, and font:Īxis title: Type Fiscal Month (with a space)Īfter you finish the customizations, your stacked column chart looks something like this: The first thing you'll notice is that your visualization now has a default X-axis title. When the X-axis title is On, the X-axis title displays below the X-axis labels. It now accommodates the 14-point text without needing to display the text on an angle or with a scrollbar. Here, we've selected the second option and grabbed one of the resize bars to make the visualization wider.
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |