Forum Discussion

alisonpappas's avatar
alisonpappas
Helper III
6 years ago
Solved

Page Level Filters Viewing

Hi,   I have page level filters and I want to be able to show when they are being used, is that possible?    Example: Page level filter of regions, so if I select "Canada" a filter on the page sh...
Need Help
Tips and Tricks
  • jdbuchanan71's avatar
    jdbuchanan71
    6 years ago

    alisonpappas 

    Change it like so.

    Regions =
IF (
    ISFILTERED ( Data[Region] ),
    CONCATENATEX ( VALUES ( Data[Region] ), Data[Region], ", ", Data[Region] )
)
jdbuchanan71's avatar
jdbuchanan71
Super User
6 years ago

Hello alisonpappas 

You can write a measure to string together the selected values.  Something like this then pull that measure into a card maybe.

Countries = 
VAR _Countries = SUMMARIZE(Customer,Customer[Country])
RETURN
    IF ( 
        ISFILTERED ( Customer[Country] ),
        CONCATENATEX(_Countries,Customer[Country],", ",Customer[Country]),
        "ALL"
    )

When there is a selection it shows the listWhen there is no filter it shows "ALL"