Forum Discussion
alisonpappas
6 years agoHelper III
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...
- 6 years ago
Change it like so.
Regions = IF ( ISFILTERED ( Data[Region] ), CONCATENATEX ( VALUES ( Data[Region] ), Data[Region], ", ", Data[Region] ) )
alisonpappas
6 years agoHelper III
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
6 years agoSuper User
Change it like so.
Regions =
IF (
ISFILTERED ( Data[Region] ),
CONCATENATEX ( VALUES ( Data[Region] ), Data[Region], ", ", Data[Region] )
)