Forum Discussion
Two Axis for Clustured Bar/Column Chart
Community ChampionIt looks like you have it displayed there in your image, You might try it as a line and column chart, that will typically give you 2 axis. What is the second axis for? Does it normalize the data somehow or how does it look different than below?
You could always check out the custom visuals or use an R or Python visual.
I need the second x-axis just to normalize the data. Count is always much more than UserCount. Without a separate axis it is very difficult to read / interpret the UserCount columns.
I tried the line and column chart but the line is the wrong visualization type for this data. I set the line stroke to 0 and enabled the visualization of the data points. But the result was not good. The data points were hard to read. Count and UserCount should be shown as columns.
Creating custom visuals or R/Python visuals is beyond the effort I have planned to invest.
HI jbe,
AFAIK, current power bi not contain visual who suitable for your requirement, I'd like to suggest you to use r visual to manually draw graph with multiple axises.
If you are not familiar with r script, you can also consider to write a measure to modify unit.
count of column(10x) = COUNT ( table[column] ) / 10
Regards,
Xiaoxin Sheng
I understand that there is no easy solution for my requirement. I'm not familiar with R Visual and I cannot modify the unit (e.g. show Bars in % with the highest one = 100%) as we need the absolute numbers.
Thanks for the help.
