Count and sum values not showing in bar chart together

[ykannan]

Hi,

I was trying to re-create a other BI report in PowerBI. I am unable to show DO count and sum of item sales in a clustered column chart. But able to show Line and clustered column chart.


Other BI Tool

What am I doing wrong here? 

[amitchandak · Accepted solution]

@ykannan , Power bi does not have the option to show the bar on both axes in case of combo visual. So you have to use the line on secondary Axis

[Ritaf1983 · Accepted solution]

Hi @ykannan 

In Power Bi, combination graphs can only combine bar graphs and line graphs.
A cluster type graph cannot be drawn correctly because it lacks proportion of your measures.

Furthermore,
In terms of correct and efficient data visualization, graphs with 2 Y axes have a problem.

There are 2 solutions I recommend:
Make two small graphs and place them next to each other.

As shown in the picture:

Create a table graph that can be formatted using conditional formatting, as shown in the following example:

For your convenience, I have attached a file with the sample
https://drive.google.com/file/d/1V5jy2p9CE0DJSC9oHb3ltVzXj9oT4rCb/view?usp=share_link 

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

[amitchandak · Accepted solution]

@ykannan , Power bi does not have the option to show the bar on both axes in case of combo visual. So you have to use the line on secondary Axis