Forum Discussion

JKammer's avatar
JKammer
Regular Visitor
10 years ago

Scatter Chart and Play Axis Date Formatting Issue

  I'm new to PowerBI and I have been evaluating the product. Right now all my data tables have been built from Queries against  a SQL Server Database During my experimentation I ran into an issue ...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
10 years ago

Hi JKammer,

 

Based on my test, the field placed in Play Axis property needs to be time-based field. If we want to get year hierarchy available, the field's data type should be Date or Date/Time type, otherwise it will display as text values instead of years.

 

So in your scenario, please check the data type of the field which you have placed in Play Axis property. And also you can try to update the Power BI Desktop to the latest version 2.37.4464.461.

 

 

If you have any question, please feel free to ask.

 

Best Regards,
Qiuyun Yu

JKammer's avatar
JKammer
Regular Visitor
10 years ago

Quiyun,

I just upgraded to 2.37.4464.461.

The field in the Play Axis was a Datetime and I have switched the field between both Date and Datetime and neither resolves the issue.

If I change the Play Axis Option on the Date field to (Date) the Chart will display the individual Dates but I need to display the Heirarchy as you have.  When I change it to Heirarchy I get the display below.

 

Thanks, for the help and any additional advice.

 

  • Aakesh's avatar
    Aakesh
    Frequent Visitor
    9 years ago

    Can we select every bubble at once without using Ctrl to trace the progress?