Forum Discussion
Visualisation problem
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,...
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!
😁😁
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?