TJ Brown on 10 Feb 2015 03:08:47
Currently, there's no sorting mechanism for the reports in PowerBI.com. We need a mechanism to sort categories by their associated measure values.
- Comments (14)
RE: Sorting ability for reports in PowerBI.com
Agree, this is not fixed. Need to sort by count of values within a month, so the categories with the largest counts show at the bottom of the stacked column.
RE: Sorting ability for reports in PowerBI.com
This is NOT completed you Liars at Microsoft!!!!
RE: Sorting ability for reports in PowerBI.com
I'm going through the same issue. For some reason, I can't sort my data by sale amount as it is pre formatted to sort my data by alphabetical order after drilling it down. Is there anything I can do to fix this?
RE: Sorting ability for reports in PowerBI.com
I'm having this same issue. Creating a dashboard for responses to a survey. I have stacked bar graphs that show number of responses from 'strongly disagree' to 'strongly agree', but Power BI sorts these alphabetically which makes no sense on the chart. I obviously need to have negative responses in red on the left, and positive responses in green on the right and I can't figure this out. It seems like such a basic function I don't know how this isn't already possible.
RE: Sorting ability for reports in PowerBI.com
Hi
I imported data from excel.When I create a line graph the days are not displayed in order (i.e on the x-axis it displays Monday Sunday Thursday...)
Please assist
RE: Sorting ability for reports in PowerBI.com
If you click on the "..." on the top right of the chart, there is an option to "Sort by". Choose the field that you see fit.
RE: Sorting ability for reports in PowerBI.com
Please provide option to sort on Month as shown in the example of the Power BI app.
RE: Sorting ability for reports in PowerBI.com
Will - on May 11, you said the next Power BI update would include the ability to sort one column by another. Please list the steps to sort by another column here. I can't find it. Thx
Will Thompson (Product Manager, Power BI, Microsoft Power BI) commented · May 11, 2015 09:37 · Flag as inappropriate
In the next release of the Power BI Designer we'll expose the ability to sort one column by another (as you could in PowerPivot).
RE: Sorting ability for reports in PowerBI.com
Any updates on this topic?? I'll be a really helpful feature... tahnks!!
RE: Sorting ability for reports in PowerBI.com
Hi Will. Right clicking on a bar graph does not bring up any menu. It is not sorted by date and I need it to be. Can you advise ? Regards, Keith