Forum Discussion

Helper II

9 years ago

Solved

X axis not aligned

The X axis months on my charts are not aligned with the bars. For example, "Jan 2017" is aligned under December data. And this will repeat itself next month and the month after. But with different mo...

Need Help

Vvelarde
9 years ago
cnpdx

Format of Visual--X Axis--Type

cnpdx

Helper II

9 years ago

not really comfortable sharing the file. but what kinds of possibilities do you see that could make this happen? im pretty sure my relationship between the dynamic date calendar and the sales table are correct.

Baskar wrote:
Cool dude,

It is really miracle to see this am surprised.

Can u please share the data to validate.

My personal thinking : This is not possible to show like this.

Note :
U have to check with your data or relationship between.

Let me know if any help.

alanhodgson

Solution Supplier

9 years ago

Hey cnpdx,

No need to share the file, but if you could share the relationship between the tables that would help. Also, how is the date column (used in the graph) formatted and what is the data type? Finally, I would look at the sorting on the date column, is it sorted by another column?

Hope this helps,

Alan

cnpdx
Helper II
9 years ago
share the relationship between the tables that would help.
1 date from the dynamic date table to many dates on a transaction table

Also, how is the date column (used in the graph)
I use month end dates for everything-for example all sales no matter what date in july fall under 7/31
how is it formatted and what is the data type?
Data type: date

Finally, I would look at the sorting on the date column, is it sorted by another column?
Its sorted by itself

thanks for your help!
- v-sihou-msft
  Microsoft Employee
  9 years ago
  cnpdx
  
  Does your fact table contain records without connecting to any date?
  
  Based on your screenshot, it looks like you have "blank" category for your fact data, and you can see you already have 12 columns before the Jan 2017. So please verify the connecting date key column in your fact table.
  
  Regards,
  - cnpdx
    Helper II
    9 years ago
    v-sihou-msft
    Hi, thanks for getting back to me
    
    Does your fact table contain records without connecting to any date? all fact table records contain a date. there are no blanks, guaranteed
    
    Based on your screenshot, it looks like you have "blank" category for your fact data, and you can see you already have 12 columns before the Jan 2017. So please verify the connecting date key column in your fact table.
    
    where are you seeing the "blank category"? Here is a screenshot of the relationship. it's one to many: transaction date id from date table to many on fact table