Forum Discussion

jbe's avatar
jbe
New Member
7 years ago

Two Axis for Clustured Bar/Column Chart

I would like to use the clustured bar chart with 2 x-axis. I use these charts with exactly two "Value" set. I have seen that a secondary axis is supported by Combo charts but not for the chart I nee...
Need Help
jbe's avatar
jbe
New Member
7 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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

  • jbe's avatar
    jbe
    New Member
    7 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello,

       

      I have a similar problem. 

      I also would like two axis in a column chart.

      I want to split my data by region and by date. 

       

      I don't seem to be able to do both at the same time, as I did on Excel.

       

      Thank you for your help,

      Solene