Forum Discussion

Lobojo's avatar
Lobojo
Helper I
4 years ago
Solved

Barchart with aggregation

Hi,   in Excel I was able, from a simple file with 2 levels, to create a bar chart were one of the levels were aggregated, using a Pivot table please see example below.   Is there any chance to d...
Need Help
Tutorial Requests
v-easonf-msft's avatar
v-easonf-msft
Community Support
4 years ago

Hi, Lobojo 

You need go to the "Format" pane of the "clustered column chart" and turn off the option "Concatenate labels".

Best Regards,
Community Support Team _ Eason

 

  • Lobojo's avatar
    Lobojo
    Helper I
    4 years ago

    Thanks a lot, it worked with a stacked column graph but not with another stacked column (nothing happened). You possibly know why? They are quite the same type of visual, I don't know if there is any element that prevent the usage of this feature

    • v-easonf-msft's avatar
      v-easonf-msft
      Community Support
      4 years ago

      Hi, Lobojo 

      This has something to do with the ordering of the fields you add on your axis.

      For example:

      Best Regards,
      Community Support Team _ Eason

      • Lobojo's avatar
        Lobojo
        Helper I
        4 years ago

        Very strange, it doesn't work either changing the order. Let me try to do few test.

         

        Anyway, thanks a lot.

  • ghoshabhijeet's avatar
    ghoshabhijeet
    Solution Supplier
    4 years ago

    v-easonf-msft  I tried to do the same as you mentioned in your snapshot. Could you please tell me why doesn't it work with May 2022 version of Power BI desktop? Am I missing something here ?