Forum Discussion
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 show's that Cananda is being shown, or Canada, US, and Europe, or US and Europe, ect.
Change it like so.
Regions = IF ( ISFILTERED ( Data[Region] ), CONCATENATEX ( VALUES ( Data[Region] ), Data[Region], ", ", Data[Region] ) )
4 Replies
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"
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.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?
Change it like so.
Regions = IF ( ISFILTERED ( Data[Region] ), CONCATENATEX ( VALUES ( Data[Region] ), Data[Region], ", ", Data[Region] ) )
