Scatter chart color saturation based on latest date

[JenaT]

I have a scatter chart based on sales data for events. Each event also has a date when the event was held. How could I base the bubbles color saturation on the dates of the events?

Power BI does not let me select the dates to the color saturation. 

[v-piga-msft]

Hi @JenaT，

Have you had a legend in your scatter chart?

If you have, it seems that you may not add another column to your color staturation. You need to remove the legend then add the column to Color saturation.

By my test we could add date type column to color staturation, but the value will be counted automatically, in that case, for each dot, the corresponding saturation value is the same which results in the same color displayed on chart.

We may could add calculated column or measure into the color saturation field. In my test, it worked fine to affect to color saturation for each dot. You should note that the column or measure that added to color section should be numeric values. 

Best  Regards,

Cherry

[JenaT]

Thanks.

I took those dates for saturation from the sales table, where the dates were duplicated on different rows and he didn't like that.

I now took the dates from another table, converted the dates to a number (format yymmdd). Selected the calculation of max/average/sum (those give the same result). But now there are only two colors for the saturation: greener one for dates in year 2018 and pale one for 2017 (dates range from April 2017 till May 2018). How could I get a variety of saturation?

[Anonymous]

I'm not familiar with Bubble charts not allowing dates for the color saturation but you might want to try to convert the date to a string using the FORMAT function. Then you will be able to put that "pseudo-date" in the saturation well.

Hope this helps,

Parker

[JenaT]

I created a new column format (.. "ddmmyyyy"), which is a number. But if I use in for saturation then it only offers me the "count of " value. How could I get him to show me the unique value or the max value for each bubble?

[Anonymous]

it only works with true numbers unfortunately.. it does not work with dates or text. They should fix this however since you in many cases want dates on the X-axis.

[JenaT]

@Anonymous But if I format to yymmdd, then I can get a number and it seems to be fit for saturation, although I still am not getting the array of colors, but only two colors (dependent on the year)