I'm newbie on PBI and I want to create a chart which I have already have on excel.
I have a dataset with timestamp values. The timestamp values are so frequent I want to show them all on one view, but I couldn't do that. As far as I know I need to group timestamp on x axis but I need to show all labels on scatter chart.
My dataset looks like;
The view which It need to be looks like.
I tried to group timestamp values like 30-40 minutes interval but when I do that I couldn't show all values on the chart. It always needs aggregation. I don't want to aggregate my measure. I need them separetly.
You can find the all dataset and pbix file on this drive link.
Hi @baueduc298 ，
You need to setting 'sort by' x axis fields before turn off this option, then label will been expanded to multiple rows.
Fianl outpur result:
And you also could try like below:
Step 2, create visual:
Step3,click as the below,and short by x column:
Step 4, close concatenate labels:
Did I answer your question? Mark my post as a solution!
It isn't working for scatter chart.
I have still 2 problem for scatter chart
1- Continuous X axis
2- Don't Concatenate Label for X axis.
@baueduc298 , You need have DateTime on X axis as categorical . In all other option it will group data .
Scatter visual , In that if you want use some time bucket then you can use datetime as details
Hi @amitchandak ,
Thank you for your answer but It doesn't work for me.
I think It was about 2 reason.
1- When you have more than 1 dimension in x axis, continuous option is not working.
2- It still not working even you have only 1 dimension(timestamp) on scatter chart.
I need x axis like that,
But It always shows like that.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!