cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jason2500
Helper I
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.

 

Please advise

1 ACCEPTED SOLUTION
v-robertq-msft
Community Support
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:

v-robertq-msft_0-1613719541797.png

 

  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:

v-robertq-msft_1-1613719541807.png

 

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

View solution in original post

2 REPLIES 2
v-robertq-msft
Community Support
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:

v-robertq-msft_0-1613719541797.png

 

  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:

v-robertq-msft_1-1613719541807.png

 

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

View solution in original post

amitchandak
Super User IV
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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Get Ready for Power BI Dev Camp

Power BI Dev Camp - June 24th

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors
Top Kudoed Authors