cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
patto_factory
Frequent Visitor

Card Browser Broken (Sorting doesnt work)

Hello All

An update seems to have been made to the Card Browser visual and broken it (OR since the latest release of Power BI Desktop) and is making the sorting field useless. I am unable to sort by anything other than the DocumentID.

 

Please help, this visual was very useful where I have clients in cards but sorted them by position in the queue.

Is this a problem for others?

Thanks, Patto

 

UPDATE: Ok this is driving me nuts, I had a workaround by being able to sort using the "Preview" column - I had to work some HTML in there to ensure it sorted correctly, but now that option seems to have disappeared too. It seems that now you can only sort by the DocumentID field.

 

Has anyone got any ideas or help please? How can we get this fixed?

Cheers Patto

6 REPLIES 6
tczuckers
New Member

Was this ever resolved?  The workaround doesn't seem to work for me. 

 

I have a faairly extensive database of users/members of our center and use this card to display them and their information.  Without a real sort I get weird results, results that change depending on the order I put the fields into the card and if I delete them, sometimes that ordering remains.

 

WAIT!!  I just got it to work in an entirely different way.  I put the field IO want to sort by in the document id, I then sort by that field, then I put the field I had there back.

 

  1. DocumentID had ID has it's original field
  2. I want to sort by last name
  3. put lastname in the DocumentID field
  4. sort by last name using the 3 dots menu
  5. change to ascending
  6. replace Last Name in the Document ID field with ID

SORTING STAYS the SAME!

v-stephen-msft
Community Support
Community Support

Hi @patto_factory ,

 

Can you provide some screenshots of the error? In my test, the sorting works.

vstephenmsft_0-1639384649922.png

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-stephen-msft 

I'll get those screen shots happening in the morning (Australia time). 
What version of power bi desktop are you using? I rolled back to September today and it works again. Could either be a November release issue or perhaps something to do with a preview feature like the formatter pane or something?

Screenshots coming soon 

cheers 

Hi @patto_factory ,

 

My desktop version is July 2021.

vstephenmsft_0-1639448726737.png

 

When I upgraded to the latest version, sort still exists. It's called 'sort axis'.

vstephenmsft_1-1639448766138.png

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for your response @v-stephen-msft  and apologies for the late reply, I have been super busy with clients leading up to christmas.

 

I can see that even in your example above, sorting is broken.

See how you only have the option to sort by the column you put in the DocumentID field?

Whereas in your earlier version of power bi desktop, you have more sorting options.

 

**And I note that in the latest PBI Desktop release, the card browser visual doesn't even let you sort by the field you add to the "sortingfield" column in the visual.

 

Here is my example:

Pre-november release:

patto_factory_1-1639522442305.png

 

 

 

Post-Nov release

patto_factory_0-1639522272495.png

 

I am now 100% convinced that either that latest release of Power BI Desktop has broken something (and wonder how many other visuals are impacted) or the card browser visual requires an update.

 

Thoughts??

Thanks

Patto

I can't believe this has still not been fixed. The issue is clearly exactly as described by patto.

I have found a workaround however, which is to put the metric to sort by in the Content field. Other metrics can appear in the metadata fields but suggest keeping Title and Preview fields as text rather than numeric.

It still seems pretty erratic but if you start from scratch with this it should work. Adding the same metric to the Sorting Field also a good idea, even though it doesn't appear in the 'Sort by' list as it used to in the old (working) version.

The drawback is you get the value displayed when you expand the card preview.

Helpful resources

Announcements
Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Power BI Dev Camp Session 26

Ted's Dev Camp - October 6, 2022

Watch the playback of Session 26 with Ted Pattison!

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Ignite 2022

What's Next at Microsoft Ignite 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Top Solution Authors