cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Markleton Regular Visitor
Regular Visitor

Displaying settings of filter based on Primary Filter on same table[column]

Hi All

I have a report that contains a slicer/filter (source: Extensions[Name]) that is used by department managers to select their team members. This filter affects all pages of the report.

Supplementary to this is a second slicer/filter (source: Extensions[Name]) that is used to show data specific to 1 or more team members on 2 of the report pages.

The normal process of creating a measure using If(ISFILTERED(Table[Column]),"All",CONCATENATEX(),... works until the second filter is used. The measure will return the details of the second filter, but obviously not the first (although on the slicer all the originally selected values are still selected). Is there any way to 'preserve' or identify this original selection?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Displaying settings of filter based on Primary Filter on same table[column]

@Markleton ,

 


The normal process of creating a measure using If(ISFILTERED(Table[Column]),"All",CONCATENATEX(),... works until the second filter is used. The measure will return the details of the second filter, but obviously not the first (although on the slicer all the originally selected values are still selected). Is there any way to 'preserve' or identify this original selection?


Maybe HASONEFILTER() can be more clear, but what does "'preserve' or identify this original selection" mean? If you mean not to remove the first filter when you select the second slicer, then I would suggest you to make a category hierarchy, put the primary selection column to the first slicer and secondary selection column to the second slicer.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Displaying settings of filter based on Primary Filter on same table[column]

@Markleton ,

 


The normal process of creating a measure using If(ISFILTERED(Table[Column]),"All",CONCATENATEX(),... works until the second filter is used. The measure will return the details of the second filter, but obviously not the first (although on the slicer all the originally selected values are still selected). Is there any way to 'preserve' or identify this original selection?


Maybe HASONEFILTER() can be more clear, but what does "'preserve' or identify this original selection" mean? If you mean not to remove the first filter when you select the second slicer, then I would suggest you to make a category hierarchy, put the primary selection column to the first slicer and secondary selection column to the second slicer.

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Markleton Regular Visitor
Regular Visitor

Re: Displaying settings of filter based on Primary Filter on same table[column]

Thanx for responding Jimmy Tao

HASONEFILTER() would not work becuse there could be more than one.

Category hierarchy would not work because the values of both slicers are the same source.

However, returning to the report this morning, the filtering is working fine. I have 3 values selected in the first and 1 in the second filter/slicer. On the pages that the single filter should apply i am getting data filtered correctly AND all the other pages are still displaying data filtered by the 3 values.

I will mark your post as Accepted to close the post.

Helpful resources

Announcements
Ask Amanda Anything Q&A

Ask Amanda Anything Q&A

Learn the answers to some of the questions asked during the Amanda Triple A event.

October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Solution Badges

New Solution Badges

Two waves of brand new solution badges are coming! Read the article for more information on our new community badges.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 481 members 4,357 guests
Please welcome our newest community members: