Forum Discussion

wherdzik's avatar
wherdzik
Helper III
2 years ago

Bar Graphs make same width?

 

Hello, I do not like the way it looks everytime I select a new filter the widths change...need some ideashow to make this unform in appearance. Any ideas? or maybe a differetn visual style?  Just need a helping hand.

 

3 Replies

  • Hi wherdzik 

    Unfortunately, we don't have the wanted functionality (included in graphs in the marketplace).

    There is an idea about this issue, you can vote for it here :

    https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=cbd4afec-18f8-4e81-ae5d-0e55f5c7777d

    I voted 🙂

    Alternatives :

    EASY :
    You can use a table with conditional formatting with bars :

    The pbix is attached

     

    Complex

    If you want to try to create the graph yourself you can try using Charticulator / Deneb.

    https://www.youtube.com/watch?v=PGyx7m4gTlU

    https://www.youtube.com/watch?v=j1Q4cDencb8

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.

  • Hi wherdzik ,

    You can use a dummy measure which I think you already did in your fourth bar graph. Example:

    Dummy = 1

    This will give the same length for all bars. Use the correct measure as custom data label to show the correct value. Use the same correct  measure as a visual where it is not blank to hide bars that don't have  value depending on a slicer selection or cross-filtering.

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI wherdzik,

    AFAIK, current power bi does not support these. If you want them show with the same width, perhaps you can try to change the visual to percentage version, the data labels will convert from numeric to percent.
    After these operations, these charts will display with similar layouts when the data labels have same percentage.

    Regards,
    Xiaoxin Sheng