Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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:
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] )
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
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:
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] )
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
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |