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 on top of its list?

more than that, when you navigate from a page where you filtered to another one how you horned on what filters and items you are on report? can i make a current selection box like on other BI softwares?

Thanks,

Cosmin

 

 

Need Help

6 Replies

  • 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