Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

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.       

2 Replies