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

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Ok understood.  thanks alot for your steps.

         

        i will try and update you with solutions :)

         

        Best

        Chanty