Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
Please assist.
My data displays after every 30mins on the X-axis. but I want the X-axis label to show after every 4 hours or 5 hours
(X-axis display label only)
I have tried using bin in grouping but it distorts the 30mins display data as all i want is just the label so my x-axis dont look clustered and can be easily read.
Also I want the label orientation to be horizontal instead of vertical.
See attached. What I want is as shown on the left and not as is on the right.
Please help
Hi @Anonymous,
I have tried using bin in grouping but it distorts the 30mins display data as all i want is just the label so my x-axis dont look clustered and can be easily read.
Also I want the label orientation to be horizontal instead of vertical.
What if you simply use Continuous type for X-Axis?
Based on my test, by using Continuous type for X-Axis will adjust the label automatically, so the X-Axis don't look clustered and can be easily read.
Before using Continuous type for X-Axis.
After using Continuous type for X-Axis.
Regards
Hi,
I've used the continous but get attached meshed lines. This happens when i select a particular day in the above bar chart. The bar chart is in categorical. Did you select a particular day from the bar chart??..What else did you do. I have tried this severally before but keep getting the meshed line graph unlike what you are showed here. Please help
Hi @Anonymous,
Could you share a sample pbix file which can reproduce the issue, so that we can help further investigate on it? You can upload it to OneDrive or Dropbox and post the link here, or sent it to me in private message. Do mask sensitive data before uploading.
Regards
Perhaps try categorical and adjusting your minimum category width? You also might have to look at a custom or R visual.
Thank you for your suggestion:
My X-axis is already on categorical.
Please How can I adjust minimum category width?..Where is the option for such..
Also which custom or R visual to achieve this??
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |