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