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

 

 

View solution in original post

Hi Lucien,

thanks for the links and the information.

View solution in original post

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
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors