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

 

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks AlB  for your guidance.  i  have implemented this working fine :)  

      i  just modified  code instead of applied filter.values   i have given my field name :)  by that user can know from which field the value selected.  

       

      created two seperate measures and  final measure clubbed first two measures and added cascade object to the final measure  :)

       

      Best

      Chanty