Forum Discussion

Chanleakna123's avatar
Chanleakna123
Post Prodigy
8 years ago
Solved

Dates Gap shown nothing in Visualization

 

Hi Everyone, 

I'm new in BI , 
I had created Date Table with my fact table. The quantity in my fact table and the date table look so gap and inappropriate. 
But I do create the relationship between fact table and date table. 
Anw , looks the collars are really in gaps which is not my purpose. The gap shown nothing of the quantity in the visualization. Even i filter it there're also show me the date which has nothing qty. Please assist me on this case. 
please assist me on this case. 

2 Replies

  • v-jiascu-msft's avatar
    v-jiascu-msft
    Microsoft Employee

    Hi Chanleakna123,

     

    You can try this option as the blue arrow shows.

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    Best Regards!

    Dale

    • Chanleakna123's avatar
      Chanleakna123
      Post Prodigy

      Perfect. you saved me again :D 

      Thanks you so much dear :)