Forum Discussion

cnpdx's avatar
cnpdx
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's avatar
    Vvelarde
    9 years ago

    cnpdx

     

    Format of Visual--X Axis--Type

     

v-sihou-msft's avatar
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's avatar
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