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 have the following line and stacked column chart. Effective Duration in green and work order count in black are both measures. For days when there is no duration data there is no bar displayed (as I wanted). But for days when there is no work order data I want the line chart to display zero (basically the yellow line instead of the black line). Can Power BI achieve this ? My axis is continuous and I want it that way and not categorical.
Hi @Capstone,
Can you mark the proper answer as a solution please?
Best Regards,
Dale
Maybe you can try however the black line is calculated to replace empty values by 0.
IF(ISBLANK([Value]),0,[Value].
Or you try something like
SUMX(DateTable,Related(Table[Value]))
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 |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |