In Scatter plot chart ,how to show all the fiscal year quarter in x axis

[Prag_02]

I am having fy/quarter in x axis and total probability % in Y axis(need it without summarization).If i am  choosing x axis as categorical then it is showing all the fy/quarter but it's asking for summarizing y axis ,which i can not do as per the requirement.to solve this i created another column fiscal year quarter like(2024.1,2024.2..)which i want to show in x axis .
if i am  choosing contineous x axis it's not showing all the fy/quarter in sorted order .it's showing the quarter in .5 difference.how to  solve this issue.Please provide a solution.

[Anonymous · Accepted solution]

Hi,@Prag_02 

Regarding the issue you raised, my solution is as follows:
 

1.For the first time, you can adjust the data type of your fiscal year/quarter column to change it to a text type, and if you use text, make sure that each entry is unique so that Power BI doesn't aggregate them.
 

2.Second, you can use PowerQuery to insert custom columns to adjust the display sort for your fiscal year/quarter columns:
 

3.Finally, in the desktop, select your fiscal year/quarter column to modify and sort it:
 

This way, your data is not aggregated and displayed continuously.

The following questions with similar steps are hoped to be helpful to you.

Solved: Putting stacked column chart in order - Microsoft Fabric Community

Can you share sample data and sample output in tabular format if I am misunderstanding? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

Best Regards,

Leroy Lu

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