Growth Rate in a Visual

[Till]

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_revenue_actual_month_2020_mdt =

CALCULATE (

SUM ( 'sql_revenue'[value] ),

'sql_revenue'[type_1] = "ACTUAL",

'sql_revenue'[type_2] = "revenue",

'sql_revenue'[ver_desc] = 1,

tbl_calendar[s_year]=2020

)

Measure Gowth Rate:

f_05_growth_revenue_rate_mtd = DIVIDE([f_05_revenue_actual_month],[f_05_revenue_actual_month_2020_mdt],BLANK())-1

If I now hide the zero values I can no longer see the hirachie:

if I now change the measure, the line is no longer displayed:

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

[v-luwang-msft · Accepted solution]

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-conta... 

Best Regards

Lucien

[v-luwang-msft · Accepted solution]

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-conta... 

Best Regards

Lucien

[Till · Accepted solution]

Hi Lucien,

thanks for the links and the information.

[v-luwang-msft]

Hi @Till ，

Could you pls share your pbix file?Remember to remove confident data.

Best Regards

Lucien

[Till]

Hi Lucien,

thanks for your reply.
I once created an example report.

pbix example 

Kind regards
Till

[amitchandak]

@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)

[Till]

@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