Forum Discussion

cosminc's avatar
cosminc
Post Partisan
8 years ago

current selection box

Hi how did you manage to solve this: when you  use some slicers from a page how can you see what filters are applied and what items are selected? what can i do to have the items selected on a slicer...
Need Help
Anonymous's avatar
Anonymous
Not applicable
8 years ago

HI cosminc,

 

As I said, power bi not contain visual or feature to display current selected items which filtered on current report.

 

In my opinion, you can write measure formula to display selected items from specific table.

 

Sample:

Measure =
CONCATENATEX ( ALLSELECTED ( 'Table' ), [Column Name], "," )

 

Reference:

 

ALLSELECTED Function (DAX)

CONCATENATEX Function (DAX)

 

Regards,

Xiaoxin Sheng

cosminc's avatar
cosminc
Post Partisan
8 years ago

Hi

what is the wright measure if in that table a have more columns filtered? i want to display for each in the same multy-row card.

with the measure which you gave me i put only one column and it repeats many time the value selected, i want to see only once 

thanks

Cosmin

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    HI cosminc,

     

    >>with the measure which you gave me i put only one column and it repeats many time the value selected, i want to see only once 

    It means you table contains duplicate records. Please try to use below formula to generate selected distinct items from specific table:

     

    Select Item For 'Column Name' =
CALCULATE (
    CONCATENATEX ( VALUES ( 'Table'[Column Name] ), [Column Name], "," ),
    ALLSELECTED ( 'Table' )
)

     

    >>what is the wright measure if in that table a have more columns filtered? 

    Allselected function with table will get all filter effects from table, if you not want other column filter effect other column you can use all select(table[column]) to instead.

     

     

    Regards,

    Xiaoxin Sheng

     

    • cosminc's avatar
      cosminc
      Post Partisan
      8 years ago

      Hi,

      it doesn't work

      now they appear all the possibilities from a column, each posibility once; 2 problems: 1. when i don't select anything i want to be clean without all these items and 2. when i select an item or more i want to see only them, not all items.

      Thanks for your help,

      Cosmin