Forum Discussion
Apply Conditional Formatting on a slicer based on another slicer
Hello,
I have a report with different visuals. I want my slicer to not filter all data, but to only highlight the chosen company.
For example, in my company slicer I choose a comapany name as Korea . Instead of showing me the value for Korea only in my Exchange rate slicer visual below, I want all other values to still be visible and Korea value to be highlighted in the slicer.
I have created a new table by duplicating the existing table and created a distinct value column, I am displaying this as a Exchange rate slicer in report which is not effected by any other visuals in report.
But my requirement is I want to highlight the exchange rate slicer value which is selected in my company and it shouls also display all other values.
I am attaching screen clips for reference.
Thanks
8 Replies
- amitchandak
Super User
I doubt this can be done. Conditional formatting is not allowed in the slicer even in the horizontal orientation.
Refer if this can help
https://www.youtube.com/watch?v=cyOquvfhzNM
Or you can display in table and highlight based on the color measure
Thanks for the reply amitchandak, Is there a way around for this situation,
wherein by using any different visual i can acheive the requirement.
shzaidiHelper I
Select your slicer click on Format menu -> click Edit Intrection Now every visual in the page will show three icons on right top cornor one is filter, 2nd one is highlight and third one is no intrection. So, in your case choose 2nd icon. Now visual will show only highlight not filter.
- shzaidi
Oh yeah you are right with slicer intraction it has only two options while visual has three. so. as a way around I used map visual instead of state slicer. What kind of slicer are you using? Is there any way you can use a visual instead?
