Forum Discussion
Conditional formatting highlighting selected value in slicer
- 1 year ago
Thanks! I think I found the solution.
This was as active, but needed to be 'inactive':
Should work. Make sure your slicer is fed from a disconnected table.
Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.
Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523
Hi
Thank you for getting back with me. It does not seem to work when the table is by itself as well (I made a single table with the competitor names as well). Here is the link to the dummy report: https://we.tl/t-DkLKoSzetb
So what I would like is to have the company selected in the slicer on the left, to be either white or black on the right bar chart (I don't really care about the color at this point).
Thank you in advance!
- lbendlin1 year ago
Super User
You had disabled visual interactions.
- vbthomass1 year agoRegular Visitor
Hi!
Thank you for getting back with me. That's what I thought as well, but in your report, it doesn't delete all the other companies. In my report it does (first picture of the original post). I feel it has something to do with the settings of the slicer, although I can't seem to figure out what it is. If this is not what you mean with 'you had disabled visual interaction', could you please specify where I can find this?
This is what I get when I enable visual interaction:You also seem to have the second option, which I think could be the issue. Any idea how I can add this option to my report:
Thanks in advance already!
- lbendlin1 year ago
Super User
Please check my proposed solution again. The tables need to be disconnected.