Power BI Visuals

[Losttrack35]

How to show axis labels and data labels together?
for example: in headcount by region column chart, x-axis labels should appear as Americas(3K) ; APAC(7K) etc.

[Anonymous]

Hi  ,try below steps

To show both axis labels and data labels together in a column chart, you can follow these steps in Power BI:

1. Create a column chart: Add a column chart visual to your report canvas and add the required fields to the visual. In this case, you will need the "Region" field for the x-axis and the "Headcount" field for the values.

2. Enable data labels: Select the column chart visual, go to the "Format" pane (represented by a paint roller icon), and expand the "Data labels" section. Toggle the "Data labels" switch to enable data labels for the columns.

3. Customize the data labels: Under the "Data labels" section in the Format pane, you have several options to customize the appearance of the data labels. You can set the position of the data labels to "Inside" or "Outside" the columns, adjust the font size, choose the display units, etc.

4. Concatenate axis labels with data labels: To concatenate the axis labels with data labels, you can use a combination of the "Region" field and the "Headcount" field. Follow these steps:

   a. Create a new calculated column: In the data model view, create a new calculated column by selecting the table containing the "Region" field and selecting "New column" from the "Modeling" tab. Use the following formula to concatenate the region name and headcount:

   RegionWithHeadcount = CONCATENATE('YourTableName'[Region], " (", FORMAT('YourTableName'[Headcount], "#,0"), ")")

   Replace 'YourTableName' with the actual name of your table.

   b. Use the calculated column as the axis labels: Go back to the report view, select the column chart visual, and drag the newly created "RegionWithHeadcount" calculated column to the "Axis" field well of the visual. This will use the concatenated values as the axis labels.

   c. Adjust the formatting: Format the axis labels to suit your requirements, such as font size, rotation, or alignment, using the formatting options available in the "Format" pane.

@Losttrack35

[Losttrack35]

Hi vs_7,

First of all thank you very much for taking out time and sharing such a detailed solution.
The solution you provided should work, but unfortunately it didn't work for me, may be i did something wrong.
So, what worked for me is using "custom labels" in data label values in 100% stacked bar chart.
I created a dax concatenating different KPIs and displayed on the chart using custom labels and it worked well for me.
But again, thank you so much!! 🙂