Forum Discussion
Clustered Bar Values
I'm not sure I get what you're looking for, but you can include Column 1 on the Y-axis, SUM([Column 2]) as value (X-axis), and add a slicer containing Column 1 with multi-select.
And you could change the measure into something like
IF(DISTINCTCOUNT([Column 1])=2, SUM([Column 2]) )
to only show the chart when exactly two Column 1 values are selected.
Michiel Dear, i want to achieve this. Is it possible? i want to change values on x and y axis using slicer. These values are available in one column on different rows.
Still not getting it. This is still a bar chart as in your first question? In the Y-axis slicer, you could select e.g. 'exp 1' and 'exp 2' as I mentioned earlier. Don't see how you would select a col1 value in the second slicer for the X-axis, though. I assume the value in the chart will be the sum of the values in col 2?
Yes VALUE will be sum or average of the values in the col 2.
As far as the chart is concerned, Yes i am refering to a bar chart. Is there any possible way to select dynammic x-axis and y-axis through slicers?