Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
Hello, I want to the chart continue the line to today , there is no value make it equal zero like chart below
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]))
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 .
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 | PPM | Target | |
May-21 | 2 | 210 | 166 |
Jun-21 | 1 | 75 | 166 |
Jul-21 | 2 | 190 | 166 |
Aug-21 | 6 | 748 | 166 |
Sep-21 | 0 | 0 | 166 |
Oct-21 | 3 | 179 | 166 |
Nov-21 | 1 | 62 | 166 |
Dec-21 | 3 | 412 | 166 |
Jan-22 | 0 | 0 | 166 |
Feb-22 | 0 | 0 | 166 |
Mar-22 | 0 | 0 | 166 |
Apr-22 | 0 | 0 | 166 |
May-22 | 0 | 0 | 166 |
Jun-22 | 0 | 0 | 166 |
Jul-22 | 0 | 0 | 166 |
Aug-22 | 0 | 0 | 166 |
Sep-22 | 0 | 0 | 166 |
Oct-22 | 1 | 40 | 166 |
Add +0 to the end of your measure.
Your Measure = SUM('Table'[Value])+0
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
7 |
User | Count |
---|---|
25 | |
24 | |
12 | |
12 | |
11 |