We would like to show all dimensions for a bar graph even if there is a Null or 0 value for the following stages and projects.
Ideally, we would like to have this as a stacked bar chart, overall per stage.
Stage |
orders |
project name |
Ideation |
|
|
Ideation |
0 |
challenger |
Development |
18 |
observer |
Testing |
6 |
space station 1 |
Testing |
4 |
space station 2 |
Total number of bars to be shown = 3 (Ideation, Development, Testing)
Is it somehow possible to display all 3 stages no matter if one stage contains only 0 and null values?
We tried as follows with set expressions: Min({1}[orders])
But as can be seen below, we need the irrelevant data at the bottom of the bars to not show up.