Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Disconnected table slicer -filtering

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

Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Anonymous ,

     

    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.

3 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Community Champion
    4 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      4 years ago

      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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        Hi Anonymous ,

         

        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.