2 of 2 people found this helpful
Yes. If you can post a sample workbook example, we will be happy to help.
The only thing I'm confused on is selecting an item from the filter--if you select only one item, only one item will be shown.
You could create a parameter to choose a single bar, and then use a calculated field based on that parameter to color that bar.
Here's an example using Superstore Sales.
If you're selecting an account from the filter the logical action is that the bars will be removed.
If you use a parameter for the dropdown, you will have to refresh the parameter with new accounts every time new accounts are added.
You can create an account parameter adding the values from the account field:
Then create a formula:
If [Account] = [Account Parameter] then 0 else 1 end
Drag the formula to the color shelf and the account selected in the parameter will be a different color than the other bars.
Great minds think alike.
I am trying to use a parameter to highlight one of the bars in this Variable Width chart. The X axis is a quantity (paid Zn), the Y axis is a cost value. I created a paramater "Colour mine" so that when I choose the mine name, the bar would be highlighted.
However I think that somehow in the formula I wrote in the calculated field "Color Mine Selected" I am just linking the names so for example, when I chose "Andaychagua", the bar was highlighted but the position in the X axis changed (it appears at the beginning when it should be highlighted in the middle of the curve).
Do you know how I can change the formula in the calculated field (Color Mine Selected), so that I can highlight the bar in the right position?
My current formula for Color Mine Selected is:
when[Mine Name] then [Mine Name] end