Color by Variable

[haizman]

Hey all. First time poster, semi-long time lurker. 🙂

I'm hoping someone can help me determine if there is a way to color visuals by variable. So if I have a data table that has brand, forecasted revenue and actual revenue. Then as I slice that it would be able to change the color of the visuals based on which brand it is displaying.

Thanks!

[dearwatson · Accepted solution]

I cant wait for the day we add a measure/column to the colour field. until then we have to fudge it.

I have done this with a combo graph like below... its OK as long as you have data like in the table on the left.

or you could overlay two line graphs if that suits your needs.

The Brand column is put into the legend field and the forecast and actual measures are simple SUM(Forecast) type

Unfiltered

[haizman]

@dearwatson, thanks for the quick response! Is there any way to do this on the gauge visual? 

[dearwatson]

Sorry I dont think any of the gauges support having a Legend so I doubt it is possible.

Cheers

Greg

[haizman]

Thank you!