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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
MSAYED26
Helper II
Helper II

need help

Hello, I want to the chart continue the line to today , there is no value make it equal zero like chart below 

MSAYED26_0-1719231995238.png

MSAYED26_1-1719232142761.png

 

5 REPLIES 5
v-kaiyue-msft
Community Support
Community Support

Hi @MSAYED26 ,

 

Thanks for the reply from @aduguid , please allow me to provide another insight: 

 

You can try this.

Measure = 
IF(SUM('Table'[value]) = BLANK(), 0, SUM('Table'[value]))

vkaiyuemsft_0-1719284975873.png

 

If your Current Period does not refer to this, please clarify in a follow-up reply.

 

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for your help ,but i have target line change every qtr not equal zero .

MSAYED26_0-1719298062037.png

 

Hi @MSAYED26 ,

 

Sorry, I don't quite understand what you are looking for, can you add more description so we can better understand your problem?


Also, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.

 

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks for your time, in count value that cell equal zero and ppm equal zero the target still have value ,so i want the target line continous have value not zero like green line .

 Count PPMTarget
May-212210166
Jun-21175166
Jul-212190166
Aug-216748166
Sep-2100166
Oct-213179166
Nov-21162166
Dec-213412166
Jan-2200166
Feb-2200166
Mar-2200166
Apr-2200166
May-2200166
Jun-2200166
Jul-2200166
Aug-2200166
Sep-2200166
Oct-22140166

MSAYED26_0-1719307251442.png

 

aduguid
Super User
Super User

Add +0 to the end of your measure.

Your Measure = SUM('Table'[Value])+0

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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