Forum Discussion

haizman's avatar
haizman
Advocate I
9 years ago
Solved

Color by Variable

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!

  • 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

4 Replies

  • dearwatson's avatar
    dearwatson
    Continued Contributor

    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's avatar
      haizman
      Advocate I

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

      • dearwatson's avatar
        dearwatson
        Continued Contributor

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

         

        Cheers

        Greg