How to show only less value when click on slicer?

[saranp780]

Hi, expertise on Power Bi.

I have some data like below.

User ID               Project

PJ1402PUR	1402
PJ1402PUR	1101
PJ1402PUR	1302
PJ1402PUR	1801
PJ1402PUR	1802
PJ1701PUR	1401
PJ1701PUR	1402
PJ1701PUR	1801
PJ1701PUR	1802
PJ1710STO	1402
PJ1710STO	1701
PJ1710STO	1702
PJ1710STO	1710

PJ1401ACT	1302
PJ1401ACT	1301
PJ1401ACT	1401

What I want is when someone clicks on the project, it will be shown only the User ID for the old projects.

Such as when I click on 1401.

From this case, it will be shown the User IDs only following. 

PJ1302PUR

PJ1100STO

PJ1401ACT

And the result like this on Power BI.

And when I click on the other more new projects, 1405 or 1510 may show. If they have projects belong to the User ID.

How can I resolve this?

Thanks.

[v-frfei-msft]

Hi @saranp780,

Could you please share your pbix to me?

Regards,

Frank

[saranp780]

@v-frfei-msft

https://drive.google.com/file/d/1lnDqNO2pA-fcbewc5qPcAwIW4wLuypd2/view?usp=sharing

This is my Power BI file. Please help me.

[v-frfei-msft · Accepted solution]

Hi @saranp780,

Actually it is not possbile to meet the exact same requirement as yours. However we can use a table visual to work around.

1. Create a calculated column.

Column = MID(Sheet1[User ID],3,4)

2. Create the measures as below.

Measure = SUM(Sheet1[Column])

Measure 2 = 
IF(ISBLANK([Measure]),BLANK(),RANKX(ALLSELECTED(Sheet1),[Measure],,ASC,Dense))

3. Create a table visual and filter the table by Measure 2.

For more details, please check the pbix as attached.

Regards,

Frank

[v-frfei-msft]

Hi @saranp780,

Does that make sense? If so, kindly mark my answer as a solution to close the case.

Regards,
Frank

[saranp780]

Oh sorry. I forgot that.

[LivioLanzo]

Have you tried to edit the interactions so that the Project slicer can filter the User ID slicer ?