Forum Discussion

WilliamN's avatar
WilliamN
Frequent Visitor
6 years ago
Solved

Scatter Chart with Play Axis conditional bubble colors

Hi I have a scatter chart with play axis wherein I'd like to change the color of some of the bubbles depending on whether it's actual vs forecasted data. I've created a workaround as shown below, bu...
Need Help
  • v-eachen-msft's avatar
    v-eachen-msft
    6 years ago

    Hi WilliamN ,

     

    It has two groups of value if you put "year label" in the visual. So you need a column full with one value, but scatter chart doesn't support conditional formatting. You could post your ideas here, maybe it will be a feature of Power BI in the future.

     

WilliamN's avatar
WilliamN
Frequent Visitor
6 years ago

Hey v-eachen-msft

 

https://1drv.ms/u/s!AsUYeU9so6vjhRSGiBhwO7DcyCXo

 

I had to add dummy data, but I believe the concept still stays the same.  I have two series that need to be merged, but the color of the bubble would still need to change when the forecasted data is rendered via the play axis.

Thanks

v-eachen-msft's avatar
v-eachen-msft
Community Support
6 years ago

Hi WilliamN ,

 

It has two groups of value if you put "year label" in the visual. So you need a column full with one value, but scatter chart doesn't support conditional formatting. You could post your ideas here, maybe it will be a feature of Power BI in the future.

 

  • WilliamN's avatar
    WilliamN
    Frequent Visitor
    6 years ago

    v-eachen-msft  Thanks

     

    I suspected conditional formatting would not be feasible for the play axis.