Forum Discussion

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...

Tips and Tricks

Icon for Super User rank

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
New Member
3 years ago
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-WuSANIoaHEKdXPgZwB3lnl0H_cu-cMzTHc1xXyqw?e=hedLcZ

Here I would like to add space between bars and also, legends to be switched to X axis.
- lbendlin
  Super User
  3 years ago
  see attached
  
  Space in X axis bars.pbix84 KB
  - 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
- 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.