Space between two bars in bar graph

[Prabhu123]

Hi,

I have used a data which from two tables. I need to show in bar graph. 

While selecting values, there is nothing to define in X axis. but I have values to show in Y axis. 

While dragging the values to bar graph from different tables, it appearing one next one i,e there is no space between two bars.

How can I increase the space between bars or I need to covert that legend to X axis?

[Ashish_Mathur]

Hi,

What do you mean by "There is nothing to show on the X-axis"?  Share some data, explain the question and show the expected result.

[Prabhu123]

Hello,

Thanks for your response. Find the pbix from the link given:

https://vontier-my.sharepoint.com/:u:/g/personal/prabhu_a_gilbarco_com/EYXiX-WuSANIoaHEKdXPgZwB3lnl0...

Here I would like to add space between bars and also, legends to be switched to X axis.

[Ashish_Mathur]

Hi,

Using the Query Editor, append all tables into a single one.  Create your visual from the appended table.

[lbendlin]

see attached

[Prabhu123]

@lbendlin Sorry, I have missed out during data creation for sharing. Actually that location coloumn will not be there in tables.

Table names is North, South, West, East and 

In X axis , this table names should come. and Y axis no of vehicles should come in bars with space in between it.

Please refer the latest :

https://vontier-my.sharepoint.com/:u:/g/personal/prabhu_a_gilbarco_com/EYXiX-WuSANIoaHEKdXPgZwB3lnl0...

[lbendlin]

The approach will still be the same.

Table = UNION(
    SELECTCOLUMNS(East,"Location","East","Date",[Date],"Vehicles",[No.of Vehicles]),
    SELECTCOLUMNS(West,"Location","West","Date",[Date],"Vehicles",[No.of Vehicles]),
    SELECTCOLUMNS(South,"Location","South","Date",[Date],"Vehicles",[No.of Vehicles]),
    SELECTCOLUMNS(North,"Location","North","Date",[Date],"Vehicles",[No.of Vehicles])
)    

You can do that in Power Query too if you want.

And no, there is no way to dynamically reference table names.

[lbendlin]

or I need to convert that legend to X axis

Either that, or use a different visual.