Adding more than one measures in the Clustered bar chart?

[Jason2500]

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.

Please advise

[v-robertq-msft · Accepted solution]

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] )

2. Then I create a Clustered bar chart and place it like this:

And I guess this can be what you want.

You can download my test pbix file here

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

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

[amitchandak]

@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