cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cosminc Member
Member

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

 

 

6 REPLIES 6
Community Support Team
Community Support Team

Re: current selection box

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
cosminc Member
Member

Re: current selection box

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 rudimentarySmiley Happy

 

Thanks 

Cosmin

Community Support Team
Community Support Team

Re: current selection box

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

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
cosminc Member
Member

Re: current selection box

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

Community Support Team
Community Support Team

Re: current selection box

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

 

Community Support Team _ Xiaoxin Sheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.



For learning resources/Release notes, please visit: | |
cosminc Member
Member

Re: current selection box

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