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,

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.