Forum Discussion
Growth Rate in a Visual
Hi all,
I have a challenge with the representation of the groth rate:
I would like to hide the zero values of the previous year.
Measure:
f_05_growth_revenue_rate_mtd = IF(DIVIDE([f_05_revenue_actual_month],[f_05_revenue_actual_month_2020_mdt],BLANK())-1=BLANK(),"",(DIVIDE([f_05_revenue_actual_month],[f_05_revenue_actual_month_2020_mdt],BLANK())-1))
Does anyone have a solution how I can show the line again?
Kind Regards an thank`s for help
Till
HI Till ,
you can't manually control analyse trend line, it is managed by power bi itself and generated based on data trend.
If the fold is to be made to appear continuous，In my opinion，if value =0,you could rerturn the average between the value =0.
You also could read the following articles,wish it is helpful for you!
Trend Line Stop at Zero:https://community.powerbi.com/t5/Desktop/Trend-Line-Stop-at-Zero/td-p/1784803
Power BI: Make a line chart continuous when source contains null values (handle missing values):https://stackoverflow.com/questions/51402676/power-bi-make-a-line-chart-continuous-when-source-contains-null-values-handle
Best Regards
Lucien
Hi Lucien,
thanks for the links and the information.
6 Replies
HI Till ,
you can't manually control analyse trend line, it is managed by power bi itself and generated based on data trend.
If the fold is to be made to appear continuous，In my opinion，if value =0,you could rerturn the average between the value =0.
You also could read the following articles,wish it is helpful for you!
Trend Line Stop at Zero:https://community.powerbi.com/t5/Desktop/Trend-Line-Stop-at-Zero/td-p/1784803
Power BI: Make a line chart continuous when source contains null values (handle missing values):https://stackoverflow.com/questions/51402676/power-bi-make-a-line-chart-continuous-when-source-contains-null-values-handle
Best Regards
Lucien
Hi Lucien,
thanks for the links and the information.
Till , Try like
f_05_growth_revenue_rate_mtd =
var _1 = DIVIDE([f_05_revenue_actual_month],[f_05_revenue_actual_month_2020_mdt],BLANK())-1
return
if(_1 =0, blank(), _1)amitchandak
Thank you for your reply.
Even after changing the measure, no line is displayed in the visual.
that's how I would like to have the representation.
Regards
Till
Hi Lucien,
thanks for your reply.
I once created an example report.
pbix example
Kind regards
Till
