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,

 

>>can i make a current selection box like on other BI softwares?

Nope, power bi not support this, I'd like to suggest you create visual with measure formula to display selection.
In addition, you can also submit an idea to ideas forum.

 

Regards,

Xiaoxin Sheng

cosminc's avatar
cosminc
Post Partisan
8 years ago

Hi Xiaoxin

can you give me an example? i'm new on PBI

for example i use a date column and a slicer with it

what visualization and what measure i need to see what day is selected

again for a column named salesmen..if i select one of them, how can i see? - measure and visualisation

 

another issue is that on slicer if i select something it's not put in top of that slicer, or i don't know how; so i have a slicer with 100 items, i select the 40th item and after i don't see on that slicer or on next pages the selection; only on data vizialization a need to deduce it or what? it seems rudimentary:)

 

Thanks 

Cosmin

  • 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