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.
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.
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.
Helpful resources
Microsoft Fabric & AI Learning Hackathon
Learn from experts, get hands-on experience, and win awesome prizes.
