Showing unique value in Visual without removing duplicates in the table

Question

Hi,Can anyone help me? I have a huge databases in my server that links to power BI data table. Is there a way that I can filter to just show the unique value only in my data report (visual) without removing duplicates in my data table. Because I do not want to remove the duplicates from data table.&nbsp;Thank youMike

anonymous · Answer

Hi Nicky,&nbsp;Thank you for your suggestion. Unfortunately it doesn't solve my problem.It still shows duplicate name. Please see below ( I didn't use real data or name).If you see below, how to make Heike Voth shows only once without removing duplicates from the table.

nickyvv · Answer

Hi&nbsp;Anonymous,not sure if this is what you are looking for, but if you choose a Slicer on your report, it will by default show the unique values in your report, without doing anything to the underlying data.Does that solve your problem?&nbsp;Did this help you or did I answer your question?Then please give kudos or mark my post as a solution!My blog: nickyvv.comTwitter: @NickyvV

nickyvv · Answer

Anonymous,&nbsp;that clears things up a bit.So you want to show only values in the table visual where Number of Inspections is not blank for example? Is that correct?Then you can filter the table visual for that exact value. You can filter by a column value not being blank, that only shows you the 2nd row from the table, and will work for all the values.I put an example together that shows what I mean:&nbsp;Did this help you or did I answer your question?Then please give kudos or mark my post as a solution!My blog: nickyvv.comTwitter: @NickyvV

anonymous · Answer

Hi Nicky,&nbsp;Thank you again for your willingness to help. It is actually more complicated than that. Because I purposely duplicated every single names in the table. By doing that I will get every single employee name show up in the data visual.So I would know who hasn't done the inspection yet.Please see below.If I filter by "value is not blank", as per below illustration, I wouldn't know that Edmond Groff and Eleanore haven't done their inspection yet. At the same time, I don't want Heike Voth/Kris Marzano shows up twice.&nbsp;&nbsp;Thanks&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,&nbsp;I think the reason is in that the data is not being summarised correctly. I guess you might switch it off for numerical (and potentially date) as it was resulting in empty rows filtering off in the output visual. Can you please add it back (right-click no the field name in the visual "values" list), instead, when you create the empty records, please put 0 vs. null for the numeric fields (No of Insp, Days since). This should work - at least worked in my test case.&nbsp;&nbsp;Kind regards,JB

Forum Discussion

Showing unique value in Visual without removing duplicates in the table

9 Replies

Related content

remove duplicate value within a row

Removing Duplicates

How to stop PowerBI from automatically removing duplicates.

Removing duplicates

Remove duplicates bug