cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
quabouquet
New Member

why isn't there a type option

Hi,

I'm new to PowerBI. Maybe this a dumb question. But I did search everywhere and couldn't find a solution.

I have a time series column (freq=1day) "Report Date" as shown below:

quabouquet_1-1612904730862.png

I inserted a "line and clustered column chart". I picked "Report Date" as x-axis, "Total Cases" as "line volume", "Daily New Cases" as "column volume". Now the question is why can't I change data type of "Report Date" column? (Please see screenshot below)

quabouquet_0-1612904695451.png

In order to help clarify my question. Here is another powerbi dashboard. This is what I want:

quabouquet_2-1612905029247.png

There should be a "Type" option under "X axis" tab.

 

Thanks for any help or response!

Best,

-Y

 

 

1 ACCEPTED SOLUTION

Question solved. The solution is create a hierarchy. 

View solution in original post

6 REPLIES 6
v-xulin-mstf
Community Support
Community Support

Hi @quabouquet,

 

You can try to transfer data type in query editor as:

v-xulin-mstf_0-1613111942453.png

 

Best Regards,

Link

Hi @v-xulin-mstf 

Thanks for your suggestion. But I've transferred data type to date before I post this question. There was no 'type' option.

-Y

quabouquet
New Member

I did transfer it before I post this question. But still I didn't find "type" option under X-axis. Am I missing something?

timg
Solution Specialist
Solution Specialist

Hi,

Could you check whether the date your are trying to use is formatted as a date type? The option to switch the axis between the "continuous" and "categorical" type is only visible when a numerical or date type field is in the x-axis, since other values like texts cannot be distributed over a continuous axis. (e.g. 1,2,3,4,5,6 can be ordered continuous on an axis between 1 and 6. but abc, def, ghi, jkl cannot logically be distributed on an axis between abc and jkl). If the date is formatted as a text it will automatically interpret the values as categorical. example:

date formatted as textdate formatted as text

date formatted as datedate formatted as date

Best regards,

Tim

Thanks Tim for your response!

I do transfer it to date type.

quabouquet_0-1612906269984.png

 

Question solved. The solution is create a hierarchy. 

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.