Forum Discussion
Clustered Bar Values
Hello Everyone!
I want to display some values in Clustered Bar Chart. My table has three columns and data is available in following format.
|Column 1| Column 2| Column 3|
|exp 1 | 23.2 | 23-3-2016|
|exp 2 | 43.2 | 24-2018 |
|exp 3 | 63.2 | 21-2-2018|
|exp 1 | 13.2 | 23-8-2018|
|exp 1 | 32.2 | 20-3-2018|
|exp 2 | 93.2 | 2-3-2017|
Now what i want to do is to Use the clustered bar and on the Y-Axis i want to display TWO values of Column 1 and on the X-Axis i want to display the range of Column 2 which will be different values.
I also want to change the values on Y-Axis using the slicer dropdown or list. There can be one dedicated drop down for one value and one for another.
Looking forward to your help.
4 Replies
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?
