cancel
Showing results for
Did you mean:
Resolver II

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_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

2 ACCEPTED SOLUTIONS
Community Support

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

Resolver II

Hi Lucien,

thanks for the links and the information.

6 REPLIES 6
Community Support

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

Resolver II

Hi Lucien,

thanks for the links and the information.

Community Support

Hi @Till ，

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

Best Regards

Lucien

Resolver II

Hi Lucien,

I once created an example report.

pbix example

Kind regards
Till

Super User

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

Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
Resolver II

@amitchandak
Even after changing the measure, no line is displayed in the visual.

that's how I would like to have the representation.

Regards
Till

Announcements