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

@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 Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

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