Stacked bar Chart

[GD61]

Hi,

1° How to display the 12 numbers (for 12 months) on the left vertical axis of this stacked bar chart?

2° How to remove the "Number of" that the software added to the 2 last items of the legend ?

Thanks and regards

[Greg_Deckler · Accepted solution]

For the first one, click the visual and then click the paintbrush icon, expand Y-Axis and then choose "Categorical" instead of "Continuous". For the second one, I don't believe that there is enough information here, can you post a screen shot of your visual configuration, the column chart icon next to the paintbrush icon.

[Anonymous · Accepted solution]

Hello @GD61

For you 2nd issue, I think that the two last informations ("number of") are here because the measure does not have and aggregation function.

When you put this kind of measure in the value section, Power BI automatically add and aggregation function and named the measure created with "number of" (in case of counting) of "sum of" (for sum function).

Select your measure and check, in the format menu, if there is an aggregation function.

In case of numeric measure, all the aggregation function should be available, and after choosing the one you want to use, the name of the measure won't be "number of", but just the real name.

Sébastien

[GD61]

Thanks Sébastien and Smoupr

For the 2 last items I had "Null" values which by default were with "Text" type. I was able to convert these text type as Number.

[Greg_Deckler · Accepted solution]

For the first one, click the visual and then click the paintbrush icon, expand Y-Axis and then choose "Categorical" instead of "Continuous". For the second one, I don't believe that there is enough information here, can you post a screen shot of your visual configuration, the column chart icon next to the paintbrush icon.