Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to highlight a specific dimension in a stacked graph. Right now I can use a Background Color on the expression to focus on the key dimension value (Ford in the attached demo). Unfortunately, the highlighting is corrupting the legend that helps distinguish the values that make up the stacked bar chart (see the attached demo example). Any ideas on the how to handle this would be really appreciated.
Hi Dave,
There is a work around, the chart will behave that way since you have defined the color in background color.
You can disable legend in the chart and you can create test boxes with the colors and description and place it as legend. you can set action to select the particular department, onclick.
Hope this helps.
-Sundar
may be this be the right way
While possible for some scenarios, in our real app we have too many potential values for some of our stacked dimensions. There are filters they often use to avoid this but in some use cases they want to see the high # of dimensions. This also means the invalid options have to disappear when outside the current set (just like they do in a the real legend). I don't think it's possible for this app.
Maybe an alternative that may be easier to spot is to change the text color instead of the colors on the chart to highlight the Company 'FORD'.
=If(Make='FORD',LightRed(), black()) in Text Color
=If(Make='FORD','<B>') in Text Format
Please find attached.