cancel
Showing results for
Did you mean:
Helper I

## Adding more than one measures in the Clustered bar chart?

Hi

I am having Year column from 2020 to 2020 and corresponding sales column

I created three dax measures, such as minimum, maximum and average sales value .

I have tried to create a clustered column chart year vs minimum, maximum and average sales value. However, it is not accepting more than one measure.

Any way is there? As I want to do the comparison.

1 ACCEPTED SOLUTION
Community Support

Hi, @Jason2500

According to your description, I can understand your requirement, I think it’s achievable because the Clustered bar chart can accept more than one measure if you placed the measures into the Value of it. You can try my steps:

This is my test data based on your description:

1. I create three measures:
``````Maximum =

MAXX(FILTER(ALLSELECTED('Table'),[Year]=MAX([Year])),[Sales value] )``````
``````Minimum =

MINX(FILTER(ALLSELECTED('Table'),[Year]=MAX([Year])),[Sales value] )``````
``````Average =

AVERAGEX(FILTER(ALLSELECTED('Table'),[Year]=MAX([Year])),[Sales value] )``````
1. Then I create a Clustered bar chart and place it like this:

And I guess this can be what you want.

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

Best Regards,

Community Support Team _Robert Qin

2 REPLIES 2
Community Support

Hi, @Jason2500

According to your description, I can understand your requirement, I think it’s achievable because the Clustered bar chart can accept more than one measure if you placed the measures into the Value of it. You can try my steps:

This is my test data based on your description:

1. I create three measures:
``````Maximum =

MAXX(FILTER(ALLSELECTED('Table'),[Year]=MAX([Year])),[Sales value] )``````
``````Minimum =

MINX(FILTER(ALLSELECTED('Table'),[Year]=MAX([Year])),[Sales value] )``````
``````Average =

AVERAGEX(FILTER(ALLSELECTED('Table'),[Year]=MAX([Year])),[Sales value] )``````
1. Then I create a Clustered bar chart and place it like this:

And I guess this can be what you want.

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

Best Regards,

Community Support Team _Robert Qin

Super User IV

@Jason2500 , if it using legend then will only take one measure.

Check for some custom visual -https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals

Proud to be a Super User!

Announcements