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.
Hello all,
I need one chart stacked with multi value, it's possible ?
in my example i will need a comparison between the blue bar and another bar which adds the pink and the green, but i need to see in this bar the difference between the yellow and green? Do you have a solution ? thank you very much.
Solved! Go to Solution.
You may consider these two workarounds.
1 Use Line and clustered column chart
Create a Calculated column to re-catalog data
NewCatalog = IF('Table'[Catalog]="PAK REEL AVG"||'Table'[Catalog]="PAK REST AVG","PAK REEL AVG&PAK REST AVG",'Table'[Catalog])
Create a Measure to add values of pink and green
PAK REST AVG = SUMX(FILTER('Table','Table'[Catalog]="PAK REST AVG"),'Table'[Amt])
Then, create visual with them. Chart will look like this:
2 Use Clustered Stacked Bar Chart. This chart is provided by third-party and some features may need additional purchase. For more details, please refer Clustered Stacked Bar Chart.
Import Clustered Stacked Bar Chart from AppSource
Create visual with it. Visual should look like this.
For more details, you may refer the attached pbix file.
Best Regards,
Community Support Team _ Caiyun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If you still have problems on it or I misunderstand your needs, please feel free to let us know. Thanks a lot!
You may consider these two workarounds.
1 Use Line and clustered column chart
Create a Calculated column to re-catalog data
NewCatalog = IF('Table'[Catalog]="PAK REEL AVG"||'Table'[Catalog]="PAK REST AVG","PAK REEL AVG&PAK REST AVG",'Table'[Catalog])
Create a Measure to add values of pink and green
PAK REST AVG = SUMX(FILTER('Table','Table'[Catalog]="PAK REST AVG"),'Table'[Amt])
Then, create visual with them. Chart will look like this:
2 Use Clustered Stacked Bar Chart. This chart is provided by third-party and some features may need additional purchase. For more details, please refer Clustered Stacked Bar Chart.
Import Clustered Stacked Bar Chart from AppSource
Create visual with it. Visual should look like this.
For more details, you may refer the attached pbix file.
Best Regards,
Community Support Team _ Caiyun
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. If you still have problems on it or I misunderstand your needs, please feel free to let us know. Thanks a lot!
Hello,
I'm sorry but I'm in holliday !
A try to test your solution and I have one error message :
Can you post sample data as text and expected output?
Not enough information to go on;
please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
4. Relation between your tables
Appreciate your Kudos!!
LinkedIn:www.linkedin.com/in/vahid-dm/
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
14 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |