Forum Discussion
Order months in graphs & Conversion according filters
Good afternoon everyone, I'm new here and I recently started using power bi. I'm very fresh and I can't find the solution to this problem in any way. I only made two reports in Power BI and I'm taking a course to understand the basic directions of the application. I don't know DAX... I'm seeing something... time will help me, but I would like to understand how to resolve this situation. I have an Excel table that I imported into Power BI (table) with the respective fields. (pictures: files, table). The formats are text or numbers as seen in the image. 1) in the report view, ensure that the graphs have the months ordered chronologically and not alphabetically (the month field is in text format - Pictures: graph_1, graph_2 and month_order) and in slicer too. 2) Being able to calculate the Conversion (%) as shown in the table conversion picture ( is overall) but in the report view, when applying the filters (Property, Inquiries Type, year, month and Zone) doesn't gives me the respective changes result with these restrictions. These changes should impact automatically in the graphs (whether for months or zones - Pictures: Zone_cov & conv gauge, image conv%). Thank you for the help you can give me.
- Anonymous2 years ago
Hi, Anonymous
You can learn how to sort the X-axis months in the following article:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi
Custom sort orders in Power BI - Power BI Visuals by Nova Silva
Change how a chart is sorted in a report - Power BI | Microsoft Learn
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- AnonymousNot applicable
Hi, Anonymous
You can learn how to sort the X-axis months in the following article:
https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-sort-by-column?tabs=powerbi
Custom sort orders in Power BI - Power BI Visuals by Nova Silva
Change how a chart is sorted in a report - Power BI | Microsoft Learn
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- AnonymousNot applicable
Thanks Jianpeng Li;
Thanks for the tip and the collaboration. The dates I was able to order. I'm still trying to find a solution for the conversion rate, being able to apply filters. I'm trying, because I'm still learning DAX in depth.