Show dimension with without record

[vvvvvvvvvv]

Is it possible to show the bar without measure in bar chart?
Like the following
ColA, ColB

1,B

1,V

2,V

4,G

Is is possible to show the dimension from 1-4 in bar chart while ColA = 3 with zero record?

[lironbaram]

hi 

short answer is no, only available dimension values are presented in the chart

but you can use a calculated dimension like this 

=ValueLoop(vMin,vMax,1) where vMin in the minimum value of ColA and vMax is the maximum value 

and expression like this 

sum(if(ValueLoop(vMin,vMax,1)=ColA,ColC))

be aware that using this method might cause some performance issues in large data sets 

[Saravanan_Desingh]

One solution is.

tab1:
LOAD * INLINE [
    ColA, ColB
    1,B
    1,V
    2,V
    4,G
];

AsOfTab:
LOAD MinC+IterNo()-1 As ColA
While MinC+IterNo()-1 <= MaxC; 
LOAD Min(ColA) As MinC, Max(ColA) As MaxC
Resident tab1;

[Saravanan_Desingh · Accepted solution]