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 strangely, the order of the items in Show Table for the card are a different order to the Filtered items in the Data view.

 

 

 

 

How can I show the latest/First Item in a Card even if the value is blank? And why when I select First does it not give me the "First" item that is in the Data view?

 

Thanks

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

9 Replies

  • 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

    • gk1d09's avatar
      gk1d09
      Frequent Visitor
      5 years ago

      Hello,

       

      Thank you for the reply. This is what I get:

       

      There could be duplicates and blanks in Progress, could this be contributing to the issue?

       

      Thanks

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

        Hi gk1d09 

        Did you download my file and check it out?

        You should have created a new column, that I called Sort By. 

        This column contains unique values - see the screenshot above - that allows sorting.  Duplicates or blanks in the Progress column don't matter.

        Can you please supply a screenshot of your data columns so I can see what you have.

        Better still, can you supply your PBIX file?

        Regards

        Phil

  • v-deddai1-msft's avatar
    v-deddai1-msft
    Icon for Community Support rankCommunity Support
    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