Forum Discussion

zbpor's avatar
zbpor
Frequent Visitor
4 years ago

Multiple series line chart with conditional formatting for line color

Hi All,   I'm trying to get multiple lines chart like with using column in legend (below) but I would like to have a freedom to use conditional formatting for changing series colors. In Tableau it ...
Need Help
zbpor's avatar
zbpor
Frequent Visitor
4 years ago

Hi lbendlin,

I have attached PBI report which is based on PBI's sample dataset Test report.

I would like to apply condition formatting to line coloring, and not change each line color indivually.

 

 

 

  • lbendlin's avatar
    lbendlin
    Icon for Super User rankSuper User
    4 years ago

    First step is to create a measure or calculated column to define the color. In your case a calculated column is sufficient.

    Color = SWITCH(financials[Country],"Canada","#118DFF","France","#12239E","Germany","#E66C37","Mexico","#6B007B","#E044A7")

    Then you can apply that field in your formatting. Well, you could if that feature would work. I was really sorprised that this is either not enabled or still broken from the implementation of the new formatting pane. 

    Ironically it makes it look like it works for the data labels. But when you apply the rule it will be ignored.

     

    But when you apply the rule it will be ignored.

     

    So yes, this is definitely broken. Sorry!

     

    • zbpor's avatar
      zbpor
      Frequent Visitor
      4 years ago

      Hi lbendlin ,

       

      Thanks for your reply.

      Yeah, this is what I was expcting.

       

      Do ye remember if that option was available before they changed formatting pane?

      Beacause if so, I could report that to MS.

       

      BR

      Zbigniew Porzych