Page Level Filters Viewing

[alisonpappas]

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 show's that Cananda is being shown, or Canada, US, and Europe, or US and Europe, ect.

[Mariusz]

Hi @alisonpappas 

Sure try this.

Measure 2 = 
IF( 
    ISFILTERED( 'Table'[Column] ),
    CONCATENATEX( 
        VALUES( 'Table'[Column] ), 'Table'[Column], "; " 
    )
)

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.

[alisonpappas]

HI @Mariusz ,

It shows it many times instead of one, the data has many rows of the region. Is there a way so it only comes up once?

[jdbuchanan71 · Accepted solution]

@alisonpappas 

Change it like so.

Regions =
IF (
    ISFILTERED ( Data[Region] ),
    CONCATENATEX ( VALUES ( Data[Region] ), Data[Region], ", ", Data[Region] )
)

[jdbuchanan71]

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"