Visualisation problem

[SOURENA]

Hello,
I faced a problem that is related to the visualisation of bar chart. I imported my excel file and I wanted to associate my first column, which is the name of Merchandise, to my second column, which is the Arrival Date of them. I want to have my Merchandise in Y axis and their associated date in X axis, but the problem is that while I put the Arrival Date in the X axis, it defines it as a Continuous type instead of Categorical and I can only use Count and Count(Distinct) for the values, moreover, there is not any button to change the type of the data, and the X axis instead of being the real dates, it is 1 and 2. 

Can anyone help me please?
Thank you ever so much.

[Anonymous]

Hi, @SOURENA 

You're using a horizontal bar chart, and you need to put the date in the Y-axis:

Change it to a category:

The x-axis puts your measure or aggregation field, such as the amount:

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SOURENA]

Thank you ever so much for your informative help, the case is that I have changed the axises and it works for the date but the new problem has risen and for the X axis of the Merchandise, the name of them have not been mentioned like the attached picture, would you kindly help me to solve it as well please?
Thank you ever so much.

[freginier]

hey there! 

I think I can help you.nFirst, click on the "Arrival Date" column in your Fields pane. In the Data view (or column tools), make sure the data type of the "Arrival Date" is set as a date or text type. This will make it easier for Power BI to treat it as categorical.

Then..

• In the visual pane (where you are configuring the bar chart), click on the X-axis settings.
• If "Continuous" is selected for the axis type, switch it to "Categorical."
• This will allow Power BI to treat your dates as individual categories rather than a continuous range of values.

And also check if the dates are still appearing as numbers (like 1 and 2), check the formatting of the "Arrival Date" field in the X-axis. You may need to set the format to something like "Day-Month-Year" or whatever is appropriate for your dataset.

Hope this helps! 

😁😁

[SOURENA]

Thank you ever so much for your consideration, in essence, I cannot find X-axis settings to change the type from continuous to categorical. can you help me in that please?