Forum Discussion

TheMayneLine's avatar
TheMayneLine
Frequent Visitor
8 years ago
Solved

Dynamic Text - unsorted

Ok, I am a total nube at this Power Bi Reports. Here is what I'm doing. (which could be entirely wrong) but...

I have 3 rows of dynamic text I would like to display. It is dynamic on values from the database.
"Top sales person sold 25 cars in 2017."
"Second best sales person sold 15 cars in 2017."
"Third best sales person sold 10 cars in 2017."

I can create a query and display this in a table. But it will sort "Second...", "Third...", "Top...".
I can add a sort order column to the end. But I cannot hide this column. And if the use click the text column it sorts.
I have tried to sort the data in the data view. It sorts fine. But then when I display the data. It sorts "Second...", "Third...", "Top...".
I have tried multi-row card. It sorts "Second...", "Third...", "Top...".
I have tried a multi-row card and added my sort column to it. It will allow me to sort decending only by the sort column and I cannot hide the sort column.

I could really use a bit of help here.
Joe

  • TheMayneLine

     

    With you Sort Order Column that you created it. Select the Field with the dynamic values and go to modeling-Sort by Column and choose your Sort Order Column.

     

    Regards

     

    Victor

    Lima - Peru

2 Replies

  • Vvelarde's avatar
    Vvelarde
    Community Champion

    TheMayneLine

     

    With you Sort Order Column that you created it. Select the Field with the dynamic values and go to modeling-Sort by Column and choose your Sort Order Column.

     

    Regards

     

    Victor

    Lima - Peru

    • TheMayneLine's avatar
      TheMayneLine
      Frequent Visitor

      Thank you very much.  That was extremely helpful.