Forum Discussion
Sorting issue : when based on calculated field
Hi!
I have a seemingly simple issue regarding sorting in bar chart!
Issue 1: Documents count by Vendor
- When I just had a measure counting the documents DISTINCTCOUNT(DocumentID), it worked correctly.
- When I had to change the measure so that DISTINCTCOUNT(DocumentID&FiscalYear&CompanyCode), the sorting works initially, but when I toggle the screen, it gets reset each time. The same happens in Power BI service.
Issue 2: Amount by Vendor
- When I used the amount imported, it worked correctly.
- When I had to change the amount, to add Accounting Signs (i.e. Calculated column, if Credit, Amount*(-1)), the sorting works initially, but when I toggle the screen, it gets reset each time. The same happens in Power BI service.
In both cases, I made sure the datatype is identical and also the Power BI Icon is the same before and after the change.
TIA!
Anonymous , you have saved the visual have sorting has been selected?
- Anonymous6 years ago
The resolution was to update the relevant Bookmark associated to the toggle button.
3 Replies
- amitchandakSuper User
Anonymous , you have saved the visual have sorting has been selected?
- AnonymousNot applicable
- AnonymousNot applicable
The resolution was to update the relevant Bookmark associated to the toggle button.