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

what do the continuous and categorical type options on the x-axis format section mean?

hi all,

 

i am trying to learn more about power bi desktop. i created a stacked column chart.

in the x-axis section there is a field named "type". it has 2 options continuous and categorical.

i selected each option and the only thing i noticed was that the width of the columns changed.

 

i searched this forum, but couldn't find anything that explained these options.

 

i searched for an explaination of these options. the only page i found was this one, but it doesn't say what the options should be used for. it just says to select one or the other . . . duh!

 

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-tutorial-customize-x-axis-and-y-ax...

 

i'd like to know if someone can give me a short description of what these options are for or what they mean of when to pick one over the other.


any help would be greatly appreciated.

 

thank you

tracy

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
ankitpatira Super Contributor
Super Contributor

Re: what do the continuous and categorical type options on the x-axis format section mean?

@elz Here's the difference between the two in simpler terms.

 

Continuous axis is where values change continuously and you cannot count the number of different values. Examples include weight, price, counts etc. Basically anything you can measure or count. Categorical is where you make small number of categories. This includes type, gender, age group, etc.

View solution in original post

5 REPLIES 5
BhaveshPatel Super Contributor
Super Contributor

Re: what do the continuous and categorical type options on the x-axis format section mean?

You can customize your chart according to your data type.

 

Thanks & Regards,

Bhavesh

 

Thanks & Regards,
Bhavesh

Love the Self Service BI.
Please use the 'Mark as answer' link to mark a post that answers your question. If you find a reply helpful, please remember to give Kudos.
Highlighted
ankitpatira Super Contributor
Super Contributor

Re: what do the continuous and categorical type options on the x-axis format section mean?

@elz Here's the difference between the two in simpler terms.

 

Continuous axis is where values change continuously and you cannot count the number of different values. Examples include weight, price, counts etc. Basically anything you can measure or count. Categorical is where you make small number of categories. This includes type, gender, age group, etc.

View solution in original post

elz Member
Member

Re: what do the continuous and categorical type options on the x-axis format section mean?

hi ankit,
thank you for taking the time to explain these options in every day terms. i really appreciate it.
tracy
v-micsh-msft New Contributor
New Contributor

Re: what do the continuous and categorical type options on the x-axis format section mean?

Hi Tracy,

 

Adding some additional information.

I think you have noticed the Note: “If the X-axis is string/Boolean, the Type option will not display.”

Then the available data type could be used here should be left with number and Date/Time. (Reference: Data types in Power BI Desktop)

When we put those two kind of data into X-Axis, the Type option would show up in Format, with Continuous, Categorical available.

Continuous, means the X-Axis would show the data in a natural growth order, like 1,2,3,…… regardless of the Y-Axis data;

While Categorical would only show the part which have values based on Y-Axis, those part of X-Axis with no values in Y-Axis, would be removed.

 

Regards

RafaelKnuth Regular Visitor
Regular Visitor

Re: what do the continuous and categorical type options on the x-axis format section mean?

Thanks for the clarification. Is there a way I can change the increment manually?

 

I want to have a 24 hr count on my X-axis (0, 1, 2, 3, 4, ... ) but the default increment is by 5 (0, 5, 10, 15, 20 ...) and I would like to change the increment to 1. I couldn't figure out how to do that.

 

I found some work arounds, one of them is to change Type from Continuous to Categorical. With that, the increment changes to 1 as desired, but the X-axis is displayed in reversed order, and I can only sort in descending order Z to A, but not in ascending order A to Z.

 

I opened a thread on this subject:

http://community.powerbi.com/t5/Desktop/Displaying-values-underneath-each-bar-on-the-X-axis/m-p/4184...

 

Any help appreciated. Thank you!

Helpful resources

Announcements
Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Users Online
Currently online: 158 members 1,936 guests
Please welcome our newest community members: