Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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)

@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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.