Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

Question solved. The solution is create a hierarchy. 

View solution in original post

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

Hi @Anonymous,

 

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

v-xulin-mstf_0-1613111942453.png

 

Best Regards,

Link

Anonymous
Not applicable

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

Anonymous
Not applicable

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 Sage
Solution Sage

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





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Anonymous
Not applicable

Thanks Tim for your response!

I do transfer it to date type.

quabouquet_0-1612906269984.png

 

Anonymous
Not applicable

Question solved. The solution is create a hierarchy. 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.