Disconnected table slicer -filtering

[shreyoogp]

Hi,

I am using Disconnected Table filter for the first time, and would appreciate if anyone can suggest how to achieve this?

I have a Disconnected table with values 1 to 10 . Also another table which contains Sales value for every product.

I have drop down for selection for the Product . Then a disconnected table slicer which lists values 1 to 10 and a Bubble chart visual depicting the Sales Amount.

For a selected product in the dropdown, once the user selects the value say for e.g 2, Top 2 Sales Amount should be displayed in the bubble chart. Similarly On selecting 3- Top 3 sales value to be displayed. How to achieve this.

Appreciate for any help in this regard

Thanks

[PaulDBrown]

PLease provide sample data or PBIX file and a depcition of the expected outcome

[shreyoogp]

I have a drop down on filter like ProdA, Prod B, Prod C. Based on each Product selection  and  then select a value(1 to 10) from the disconnected table as shown below, the Bubble chart should display the Salesvalue . I am unable to reflect changes in the bubble chart when value from disconnected slicer filter is selected

DisconnectedTable TopN
1
2
3
4
5
6
7
8
9
10

[v-rzhou-msft · Accepted solution]

Hi @shreyoogp ,

Here I create a sample to show you how to filter your visual by slicer from disconnected table.

My Sample:

Measure:

Rank = 
VAR _SUMMARIZE =
    SUMMARIZE (
        ALL ( 'Table' ),
        'Table'[Company],
        "Sales", CALCULATE ( SUM ( 'Table'[Sales] ) )
    )
VAR _ADDRANK =
    ADDCOLUMNS ( _SUMMARIZE, "Rank", RANKX ( _SUMMARIZE, [Sales],, DESC, DENSE ) )
RETURN
    SUMX ( FILTER ( _ADDRANK, [Company] = MAX ( 'Table'[Company] ) ), [Rank] )

Filter = 
VAR _SELECTRANK =
    SELECTEDVALUE ( 'DisconnectedTable TopN'[Value] )
RETURN
    IF ( [Rank] <= _SELECTRANK, 1, 0 )

Result is as below.

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.