Sort Items and not Show Repated Items for Level 1

[Anonymous]

Hi Experts

See attached sample PBIX...

I do not want to include the itemgrp in my tabloe visual, but want to show the items in the order as per numbering and also i do not want repeated level 1 items shown...

sample data:

https://www.dropbox.com/s/mmcarhehvxpx9ee/Sort.pbix?dl=0 

[amitchandak · Accepted solution]

@Anonymous , I checked because of data granularity issues it is not becoming a sort column for Level 1 and Level2. I doubt you can remove and sort.