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

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"
)
    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      sorry  :) its my bad.     but still i cant add multiple  slicers in existing expression :(

       

      i added comma and  added the same way  distinct aswwell but no luck  !!!!!

       

       

      ShowMeasure =
      IF (
      ISFILTERED ( vw_daas_Total_Contract_Value_Orders[Fiscal_Year_Month_Code] ),ISFILTERED(vw_daas_Total_Contract_Value_Orders[REGION]),ISFILTERED(vw_daas_Total_Contract_Value_Orders[Data_Source]),
      "Filter aplied. Values:" & UNICHAR ( 10 )
      & CONCATENATEX (
      DISTINCT ( vw_daas_Total_Contract_Value_Orders[Fiscal_Year_Month_Code] ),DISTINCT((vw_daas_Total_Contract_Value_Orders[REGION],DISTINCT(vw_daas_Total_Contract_Value_Orders[Data_Source])
      vw_daas_Total_Contract_Value_Orders[Fiscal_Year_Month_Code],vw_daas_Total_Contract_Value_Orders[REGION],vw_daas_Total_Contract_Value_Orders[Data_Source]
      ", "
      ),
      "No filter applied"
      )
      • AlB's avatar
        AlB
        Community Champion
        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