Forum Discussion
Card First and Show Items with no data
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
Super UserHi gk1d09
Download this sample PBIX file to see the following steps/code
Add an Index (Sort By) Column in Power Query add Close & Apply.
In the Model View,click on the Progress column and under Properties -> Advanced, choose Sort by column 'Sort By' (or whatever you called it)
regards
Phil
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
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
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
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