Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
I am using the line chart to display a trend of defects by dept. Some depts has 0 defects but still required to be displayed in the chart.
To do this, I added each dept defects count into the Y-axis.
However, when selected a dept that has 0 value, 2 anomalies occurred:
1. Instead of displaying the selected dept, it shows the first dept. The correct dept is shown is selected a dept with values.
2. The 0 on the line appeared more then 1 as shown in the picture.
Are there alternate settings to resolve the above issues?
Thank you in advance!
Hi, @Anonymous,
have you created a measure, or are you using an implicit measure? Do you have a date-table?
I am not able to recreate your issue, but you could try to write a measure like this:
Measure = SUMX('Table',if(ISBLANK('Table'[value]),0,'Table'[value]))
Cheers,
Sturla
If this post helps, then please consider Accepting it as the solution. Kudos are nice too.
Hi @sturlaws ,
I am getting the data from a table like the following:
The following columns are selected for the Y-axis:
Cheers!
How have you created your slicer?
Anyway, the your table is not optimal for what you are trying to do. I would place department on rows instead, like this:
Hi @sturlaws ,
I use the "Dept" as the field for the slicer.
Sorry, I missed showing that in the table screenshot.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
72 | |
69 | |
57 | |
37 | |
36 |
User | Count |
---|---|
83 | |
67 | |
62 | |
46 | |
45 |