-
1. Re: how to highlight active filters
Zhouyi ZhangMay 11, 2017 7:25 PM (in response to Ling Qi)
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
Ling Qi May 11, 2017 9:06 PM (in response to Zhouyi Zhang)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 ZhangMay 11, 2017 10:24 PM (in response to Ling Qi)
Hi, Ling Qi
I don't think it is doable with all your 20 filters together.
ZZ
-
4. Re: how to highlight active filters
Bhujang Hundre May 11, 2017 11:41 PM (in response to Ling Qi)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
Ling Qi May 14, 2017 10:51 PM (in response to Zhouyi Zhang)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
Ling Qi May 14, 2017 10:51 PM (in response to Bhujang Hundre)Hi Bhujang Hundre,
Yes, it works. Thank you very much!
Regards,
Ling
-
7. Re: how to highlight active filters
Zhouyi ZhangMay 14, 2017 11:00 PM (in response to Ling Qi)
That's really cool.
ZZ