Forum Discussion

GD61's avatar
GD61
Helper III
10 years ago
Solved

Stacked bar Chart

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

 

  • 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's avatar
    Anonymous
    10 years ago

    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

3 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    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's avatar
    Anonymous
    Not applicable

    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's avatar
      GD61
      Helper III

      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.