How to get same top 5 customers in different visual

[Anonymous]

Hi all

I will try to explain my problem easily to you.

I have two table as Data and Date.

Data Table: 

Customer	Dimension	KPI1	KPI2
.0110163785	08	0	0
.0320053606	08	0	0
80854517	08	0	0
100183402	08	0	0

* dimension column using for date as text. It has weeks and months. Weeks are shown as 2 digits (01,02,52) and months are shown as 3 digits (01,02,12). You don't need to do anyting with this. I have already join it to my date table.

I was created two column on this table as No and Rank.
No = 1

RANK = CALCULATE(SUM(data[NO]);FILTER(data;data[Dimension] = EARLIER(data[Dimension]) && data[KPI1]>=EARLIER(Data[KPI1])))

Date Table:

Index	ID	Dimension	Text
1	01	Weekly	W01
2	02	Weekly	W02
53	001	Monthly	January
54	002	Monthly	February

this two tables are joined on ID and Dimension columns. You can check the full data set from pbix.

Lets talk about my situation.

I added 2 date filter to page. Every date filter must be only filter the own below visual. Then when the first one selected it must be show the top 5 customers for their overdue values. I use the column to get top 5 which i have already created. (Rank)

Visual on the left side is okey for me. I want to transform to the right side visual. On the right graph, i want to show the top 5 overdue value according to the customers on the left. so, I would like to see the values ​​of the 5 customers on the left according to the filter on the right

As an example; the graph on the right should look like this.

Customer	Dimension	KPI1	KPI2
5250001688	2	198247574	269867301
6220529513	2	64402015	211471699
450310852	2	34813733	34813733
8140131899	2	34309240	115571666
1750051846	2	37990784	162748048

I really need help for this situaion. Thanks for all

You can get the pbix from there

[v-frfei-msft]

Hi @Anonymous ,

Remove the rank column of the right visual should work.

Regards,

Frank

[Anonymous]

It isn't what i'm looking for. Not working !