Forum Discussion

Prabhu123's avatar
Prabhu123
New Member
3 years ago

Space between two bars in bar graph

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 v...
Need Help
Show and Tell
Tips and Tricks
Ashish_Mathur's avatar
Ashish_Mathur
Super User
3 years ago

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's avatar
      Prabhu123
      New Member
      3 years ago

      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-WuSANIoaHEKdXPgZwB3lnl0H_cu-cMzTHc1xXyqw?e=oi3GvT

       

       

       

       

       

      • lbendlin's avatar
        lbendlin
        Super User
        3 years ago

        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.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Super User
    3 years ago

    Hi,

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