Forum Discussion

dharish20240911's avatar
dharish20240911
New Member
1 year ago
Solved

Filtering the drop slicers

Example :  I have three dropdown slicers titled as :  1)Region , 2) Country , 3) City When user select "Asia" from 1st dropdown(Region) then dynamically only related options (Countries in Asia) sh...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi dharish20240911 

     

    Currently, the dax function can not recognize place names, and if you can't join the relationships, you can only manually add calculated columns, for example:

    Here's a sample able:

    Table3;

    Add a calculated column:

    Country =
    SWITCH (
        TRUE (),
        'Table3'[City] IN { "Delhi", "Mumbai", "Hyderabad", "Chennai" }, "India",
        'Table3'[City] = "Beijing", "China",
        'Table3'[City] = "London", "Europe",
        BLANK ()
    )
    

     

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.