Forum Discussion

gk1d09's avatar
gk1d09
Frequent Visitor
5 years ago
Solved

Card First and Show Items with no data

Hello,   When I select first from the Visualisation pane for my item it does not show the first item. In table view of the card, the First items is blank and this does not get selected.    Also s...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    5 years ago

    Hi gk1d09 ,

     

    As a workaround, you can create an index column and put it in table visual too.

    For exmaple:

    Turn off word wrap for column header and reduce the column spacing to hide the Index：

     

     

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

     

    Best Regards,

    Dedmon Dai

PhilipTreacy's avatar
PhilipTreacy
Icon for Super User rankSuper User
5 years ago

Hi gk1d09 

The visual is showing you the text sorted alphabetically A-Z, and the BLANK comes before any text. So when you select the First item and see a blank, that is correct.

What you need to do is sort the visual by another column.  Either one you already have but haven't shown in your screenshot, or create one. 

Can you share some data as a file or copy/paste it - NOT as a screenshot.

Regards

Phil

gk1d09's avatar
gk1d09
Frequent Visitor
5 years ago

Hello,

 

I can see its alphabetically, I didnt really notice that. There is quite a lot of data, so sending would be hard. i do have an index column in that table, but when I select that as the Sort I get this:

I wish it would pull the data exactly as is from the dataset, then First would make sense. Or something that would just select Latest.

 

Thanks,

Graeme