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] )
)
Mariusz's avatar
Mariusz
Community Champion
6 years ago

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.
Mariusz Repczynski

 

  • alisonpappas's avatar
    alisonpappas
    Helper III
    6 years ago

    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's avatar
      jdbuchanan71
      Super User
      6 years ago

      alisonpappas 

      Change it like so.

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