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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
melissa_dor
New Member

How to change scale type of X-Axis

Hi,

 

When I try to format the X-Axis, the only Scale-Type available is "Linear".

How to I get the "Categorical" Scale-Type?

This is on a Stacked Bar Chart.

 

Thank you and kind regards,

 

Melissa

1 ACCEPTED SOLUTION
v-yuezhe-msft
Employee
Employee

Hi @melissa_dor,

When you create a stacked bar chart in Power BI Desktop, you have the chance to change type of Y-Axis rather than X-Axis to “Categorical” as long as you put numeric or Date/Time data type field to axis. There is an example for your reference. However, if you put text data type field to axis of stacked bar chart, the Type format option that contains Categorical and  Continuous will not show up.
1.PNG

In addition, when you create a stacked column chart in Power BI Desktop, you can change type of X-Axis to “Categorical” as long as you put numeric or Date/Time data type field to axis. Similarly , the Type format option that contains Categorical and  Continuous will not show up  when you put text data type field to axis of stacked column chart. Here is an example for your reference.
2.PNG

 

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

1 REPLY 1
v-yuezhe-msft
Employee
Employee

Hi @melissa_dor,

When you create a stacked bar chart in Power BI Desktop, you have the chance to change type of Y-Axis rather than X-Axis to “Categorical” as long as you put numeric or Date/Time data type field to axis. There is an example for your reference. However, if you put text data type field to axis of stacked bar chart, the Type format option that contains Categorical and  Continuous will not show up.
1.PNG

In addition, when you create a stacked column chart in Power BI Desktop, you can change type of X-Axis to “Categorical” as long as you put numeric or Date/Time data type field to axis. Similarly , the Type format option that contains Categorical and  Continuous will not show up  when you put text data type field to axis of stacked column chart. Here is an example for your reference.
2.PNG

 

Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors