Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Solved! Go to 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
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.
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.
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
97 | |
78 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |