Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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's avatar
    Anonymous
    6 years ago

    The resolution was to update the relevant Bookmark associated to the toggle button.

3 Replies

  • Anonymous , you have saved the visual have sorting has been selected?

    • Anonymous's avatar
      Anonymous
      Not applicable

      I saved the report after setting the order by preferences ... anything else?

       

      amitchandak 

      • Anonymous's avatar
        Anonymous
        Not applicable

        The resolution was to update the relevant Bookmark associated to the toggle button.