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 the...
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

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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      for one slicer also still im getting error :(

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

      where im missing?

      • AlB's avatar
        AlB
        Community Champion
        7 years ago

        Anonymous

         

        Like I just said, you need to use commas instead of semicolons in the code:

         

        ShowMeasure =
IF (
    ISFILTERED ( vw_daas_Total_Contract_Value_Orders[Fiscal_Year_Month_Code] ),
    "Filter aplied. Values:" & UNICHAR ( 10 )
        & CONCATENATEX (
            DISTINCT ( vw_daas_Total_Contract_Value_Orders[Fiscal_Year_Month_Code] ),
            vw_daas_Total_Contract_Value_Orders[Fiscal_Year_Month_Code],
            ", "
        ),
    "No filter applied"
)