Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Question about a drill down filter requirment

Hi All,

 

I have a requirement where I have to create two filters where,

1st filter - Regular filter where I have a dropdown of multiple filelds

2nd filter - Should have the values of the field selected and the filter must have the name <Values for -field->

 

Eg. Field selected in first dropdown is 'Category'. Second filter name must change to 'Values for Category' and should list the category values.

 

Can someone help me with this requirement?

General Comment
Need Help
Tips and Tricks

1 Reply

  • amitchandak's avatar
    amitchandak
    Super User
    2 years ago

    Anonymous , Values for the category you can get in the title

    You can use this measure in title of fx 

    "Values for " & concatenated(Category, Category[Category],  ", " )

     

    If the next slicer is on same table it should filter value.

     

    else you can use a measure from common fact and check for not blank to filter values

    https://www.youtube.com/watch?v=cyOquvfhzNM

     

     

    Or create a measure based on the first dimension and check for nonblank

     

    How to filter the slicer of a disconnected table: https://youtu.be/cV5WfaQt6C8