Forum Discussion

capko's avatar
capko
Helper II
1 year ago

Problem with clustered column chart

Hello,

 

I've a clustered column chart with three legends (the table where the data comes from is a pivoted table so I've 'Attributes' and 'Values').

 

For the attribute on the left, everything is OK but for the one in the right there are no values for the legend in the middle possition and I would like to just show the two bars together without the blank space in the middle. 

 

Can this be done ?

 

 

 

Need Help

3 Replies

  • rit_ty7's avatar
    rit_ty7
    Advocate I
    1 year ago

    hello capko ,
    unfortunately you can't show the two bars together without the blank space in the middle.


  • danextian's avatar
    danextian
    Super User
    1 year ago

    Hi capko 

     

    Based on testing, that's just how the  colum chart behaves. I tried some other custom visuals, but they behaved the same.

     

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hello, rit_ty7 and danextian ,thanks for your concern about this issue.

    Your answers are excellent!
    And I would like to share some additional solutions below.


    Hi,capko .Has your problem been solved?
    If you have found suitable solutions, please share them as it will help more users with similar problems.

    The bar chart visual in Power BI categorizes the data according to different dimensions (X-axis fields), so in time for some data itself is blank, in the bar chart will also show blank, this is a kind of design make

    Or you can mark the valid suggestions provided by other users as solutions.
    Thank you very much for your understanding and support of Power BI.

    I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
    Best Regards,
    Carson Jian