Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

RE: current selections

Hi All,

 

is there anyway to see all current selections done by user?

 

for example   i have year filed  ,month,product,......

 

in each filed i have selected some values.

 

how user know these are the values i selected from different fields?   is there  any object?

 

 

Best

Chanty

Need Help
  • AlB's avatar
    AlB
    7 years ago

    Anonymous

     

    I think it will be easier if you create 7 different measures instead of putting all the code directly in one.

    Once you've done that you can put each of them in a card visual or, if you prefer, you can create another measure that aggregates all the others: 

     

    TotalMeasure = [ShowSlicerContents1] & UNICHAR(10) &
               [ShowSlicerContents2] & UNICHAR(10) &
                //Continue here with the other measures...
                [ShowSlicerContents7]

     

    The UNICHAR(10) is for a  new line

9 Replies

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Hi Anonymous

     

    Where are you selecting the values, in slicers?  The user can see the selection there. Otherwise you could create a measure that shows the selection on each slicer. Check this post out. Something similar was solved on it.    

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      thanks AlB  

      but i m unable modify the measure :(  as im pretty new for coding :(

      i have slicers    Quarter,Month,Region,...like 7 slicers  how to add  these 7 scliers into this code?

      ShowSlicerContents =
IF (
    ISFILTERED ( Table1[Column In Slicer] );
    "Filter aplied. Values:" & UNICHAR ( 10 )
        & CONCATENATEX ( DISTINCT ( Table1[Column In Slicer] ); Table1[Column In Slicer]; ", " );
    "No filter applied"
)

          tried but im geeting error  you can see in Image

       

      best

      chanty 

      • AlB's avatar
        AlB
        Community Champion
        7 years ago

        Anonymous

         

        That measure is just to show the selections in one slicer. It could be modified to include more or, probably best, you could have one such measure per slicer. 7 in your case. 

        In any case the problem that you seem to have now is that you need to change the ";" separator in the original code for comma "," as you seem to have different locale settings.