Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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
Solved! Go to Solution.
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
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
Hi @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
Proud to be a Super User!
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
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
Proud to be a Super User!
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,
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
Proud to be a Super User!
Hello,
I have created the sort by index and it is still showing the same error.
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
Proud to be a Super User!
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
User | Count |
---|---|
123 | |
70 | |
67 | |
58 | |
53 |
User | Count |
---|---|
186 | |
93 | |
67 | |
63 | |
54 |