Forum Discussion

id9213's avatar
id9213
Icon for Helper I rankHelper I
2 years ago

How to avoid combining X axis values on a bar chart?

Hi,

 

I know this is a common issue but I wanted to know if someone found a solution to avoid combining values on a bar chart?

I managed to do it by creating an Unique ID, but I do not like the visual aspect.

I tried to put two factors on the X-axis, and tried to hide the one I do not need but that does not work. Not clean to just hide the first line.

Anybody found a solution to solve that?

 

Thanks a lot for your help.

 

Best regards.

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi id9213 ,

    I understand that you are looking for a way to avoid combining values on a bar chart.

     

    One way to achieve this is by using a clustered bar chart. This chart type allows you to display multiple bars side-by-side, each representing a different category.

     

    If you still face issues with combining values on the X-axis, you can try using a stacked bar chart instead. This chart type allows you to display multiple bars stacked on top of each other, each representing a different category.

     

     

    How to Get Your Question Answered Quickly 

     

    If I have misunderstood your meaning, please provide more details with your desired output and pbix file without privacy information (or some sample data) .

     

    Best Regards
    Community Support Team _ Rongtie

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

     

     

     

     

    • id9213's avatar
      id9213
      Icon for Helper I rankHelper I
      2 years ago

      Hi,

       

      Thanks a lot for your answer. Unfortunately, it does not seem to work.

      In my example, I am plotting ratings for providers that go from 1 to 5.

      But when I have several occurences for Provider 6 let's say, the graph adds all the ratings and plot someting above 5, like in Graph 1.

      I would like to have every occurence plotted without combining the values, like on my graph 2.

      But I do not like the fact that in the legend it says Provider 1_1, Provider 1_2, ... I would like just Provider 1 plotted several times like this:

       

      Do not hesitate to tell me if my question is not clear enough.

      Thanks a lot!