-
1. Re: how to highlight active filters
Zhouyi Zhang
May 11, 2017 7:25 PM
Hi, Ling Qi
Have you tried to edit the "Caption" with your own way so that you can better organize the information reading?
ZZ
-
2. Re: how to highlight active filters
Hi ZZ,
Thank you for response and great idea.
How ever, I tried to edit "Caption", some filters are not showing all members selected, example as below. How do I make "Caption" to show all member selected? or something like "The Department Name filter keeps 195 of 213 members, except for 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18"?
The Department Name filter keeps 195 of 213 members.
The Product filter keeps 24 of 30 members.
The Product Name filter keeps 6 of 20 members.
Thank you
Ling
-
3. Re: how to highlight active filters
Zhouyi Zhang
May 11, 2017 10:24 PM
Hi, Ling Qi
I don't think it is doable with all your 20 filters together.
ZZ
-
4. Re: how to highlight active filters
Hi Ling Qi,
Create new worksheet as "Current selection" and apply all filter to this worksheet,
In worksheet title insert all the dimension and measure filters used and format it in easy and readable statement.
Hope this helps you. - don't forget to mark correct and useful if it meets your requirement.
Regards
Bhujang
-
5. Re: how to highlight active filters
Thank you Zhouyi for your help, I worked out inserting a worksheet with all filter values as Bhujang Hundre mentioned.
-
6. Re: how to highlight active filters
Hi Bhujang Hundre,
Yes, it works. Thank you very much!
Regards,
Ling
-