RE: current selections

[Anonymous]

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

[AlB]

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]

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]

@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]

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]

@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]

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 · Accepted solution]

@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]

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

[Anonymous]

Ok understood.  thanks alot for your steps.

i will try and update you with solutions 🙂

Best

Chanty