cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Till
Resolver II
Resolver II

Growth Rate in a Visual

Hi all,
I have a challenge with the representation of the groth rate:
Screenshot 2021-04-17 055919.png

 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:
Screenshot 2021-04-23 045523.png
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))

Screenshot 2021-04-23 050055.png
Does anyone have a solution how I can show the line again?

Kind Regards an thank`s for help

Till

 



2 ACCEPTED SOLUTIONS
v-luwang-msft
Community Support
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.

 

v-luwang-msft_0-1619594359668.png

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

 

 

View solution in original post

Hi Lucien,

thanks for the links and the information.

View solution in original post

6 REPLIES 6
v-luwang-msft
Community Support
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.

 

v-luwang-msft_0-1619594359668.png

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

 

 

Hi Lucien,

thanks for the links and the information.

v-luwang-msft
Community Support
Community Support

Hi @Till ,

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

 

Best Regards

Lucien

Hi Lucien,

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

pbix example 

Kind regards
Till

amitchandak
Super User
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)

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
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!

@amitchandak 
Thank you for your reply.
Even after changing the measure, no line is displayed in the visual.
Screenshot 2021-04-23 070528.png
that's how I would like to have the representation.
Screenshot 2021-04-23 065820.png
Regards
Till

 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors