Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
99 | |
80 | |
70 | |
59 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |