visualizations in scatter charts and time intelligence

[kandre123]

I have a question regarding visualization of measures. I have made a Sales measure which dynamically calcluates sales based on years and other categories. The same with an EBITDA margin. My third measure is CAGR which by its nature needs several years in for it to calculate properly. What i am wondering about is if there is a possibility of freezing a three year cagr so that i can have three year cagr on the y-axis and one year EBITDA in x axis and one year sales on the bubble?

[v-chuncz-msft · Accepted solution]

@kandre123 

You may try to write a measure that returns BLANK in IF function.

https://community.powerbi.com/t5/Desktop/Forecasts-for-year-and-actuals-for-ytd-only/td-p/825702