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

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

  • gk1d09's avatar
    gk1d09
    Frequent Visitor
    5 years ago

    Hello,

    I managed to achieve what I needed using the below.

     

    Last date = LASTNONBLANK(HighlightReport[Date],1)

LatestProgress = if(HASONEFILTER(Project[ProjectID]),LOOKUPVALUE(HighlightReport[Progress],HighlightReport[Date],[Last date],HighlightReport[ProjectID],VALUES(HighlightReport[ProjectID])),"None")

    I tried with your proposed solution. The sort By column I created was just called Index. When I changed the dropdown to Sort By Index, I got the error I pasted. 

     

    Thanks,

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

      Hi gk1d09 

      Your original post showed an error caused by the column Index that you started with, which is why I renamed the column I created to Sort By.  Are you sure you weren't still trying to sort by the original Index column that had duplicate values?

      Regards

      Phil

      • gk1d09's avatar
        gk1d09
        Frequent Visitor
        5 years ago

        Hello,

         

        I have created the sort by index and it is still showing the same error.