X-Axis Categorical View

Data Visualizations
1

Hi all,

I created this visual in a separate power bi file utilizing the X-Axis Categorical view. See image #1.
But when I tried to recreate the same visual in a different report, I do not see the X-Axis Type Categorical, please see image #2.

Do you know how I can activate it? For the life of me, I tried everything but can’t seem to find how to activate it.

Image #1
image

Image #2
image
image

Thank you for your help

2

Turn off Concatenation in X-Axis.

3

Thanks pranamg but it still not working.

See the attached file.

WIP File.pbix (56.6 MB)

Thanks for your help

4

Hello @ysherriff,

Thank You for posting your query onto the Forum.

Firstly, in order to achieve the results based on the “Image 1” which you’ve provided in your initial post can be achieved as per the steps suggested below -

1). In your Date hierarchy, add the field “Month” inside it.

Add Month Field Inside The Data Hierarchy

2). Create a visual based on the hierarchy - “Year > Month”.

Visual Based On A Year > Month Hierarchy

3). Drill-down from Year level to Month level in the chart.

Drill-down from Year to Month
Drill-down from Year to Month1143×435 6.42 KB

4). Turn on the “Concatenate labels” inside the X-axis option.

Enable Concatenate Labels

Now, you’ll get the expected results as per the “Image 1”. Below is the screenshot of the final results provided for the reference -

Final Results
Final Results937×443 6.45 KB

Finally, the answer to your query -

“I do not see the X-Axis Type Categorical. Do you know how I can activate it? For the life of me, I tried everything but can’t seem to find how to activate it.”

Answer: The option of - “Continuous V/s Categorical” is available or visible inside the formatting pane only, in the case, when you’re present at a numerical level onto the X-Axis. Below is the screenshot provided -

Numerical Level At The X-Axis
Numerical Level At The X-Axis1263×583 23.6 KB

So as you can see in the above screenshot, when your X-Axis is in the form of Number or Numericals, Power BI gives you the option of converting it into either “Continuous or Categorical” type. But when you drill-down further into the next level i.e., at a Month level. The X-Axis is now in the form of Text level since Month is in a Text format. And therefore, at this level, the option of “Continuous or Categorical” is no more available. The reason being is, text format cannot be of a continuous data type and hence, they’re by default converted into the “Categorical Type” Below is the screenshot provided -

Text Level At The X-Axis
Text Level At The X-Axis1250×463 23.6 KB

When you’ll drill-up then again you’ll start to see those options again.

I’m also attaching the working of the PBIX file for the reference purposes.

Hoping you find this useful and meets your requirements that you’ve been looking for.

Thanks and Warm Regards,
Harsh

WIP File - Harsh.pbix (56.6 MB)

2 Likes
5

Thank you and it worked perfectly

6

Hello @ysherriff,

You’re Welcome!!!

I’m glad that I was able to assist you.

Thanks and Warm Regards,
Harsh

7

Works thanks Harsh.

WIP File.pbix (32.8 MB)