Forum Discussion

webportal's avatar
webportal
Icon for Impactful Individual rankImpactful Individual
8 years ago

No date hierarchy

Hello,

 

When importing two tables from an Excel table, if the date field is relating the two tables, the date hierarchy isn't working in any visualization.

 

If the relationship is deleted, the date hierarchy works again. 

 

Why is this? The relationship is one-to-one (since we have exactly the same dates on both tables) and bi-directional.

 

Thank you so much for helping!

Need Help

4 Replies

  • v-caliao-msft's avatar
    v-caliao-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    webportal,

     

    Could you please share us some sample data, so that we can make further analysis. 

     

    You can upload a pbix file to Onedrive or any web storage and share the link. Do mask sensitive data before uploading.

     

    Regards,
    Charlie Liao

    • webportal's avatar
      webportal
      Icon for Impactful Individual rankImpactful Individual
      8 years ago

      Hello v-caliao-msft

       

      Here's a sample file.

       

      Sample

       

      If you delete the relationship between the two tables, then the chart will allow date hierarchy.

      Otherwise, it will not.

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Same problem in my table. After deleting the relationship the date hierarchy is working againg. But while the relationship to a date table is active, the date hirarchy in my imported excel file (with not only unique dates) is not working any more.