Forum Discussion
Total & Part Stacked Column Graph
How do I create a stacked column graph, such that 25 total from one field, n of which are have some characteristic from another field are shown in one column where the top is at 25 not 25+n? Do I have to calculate a, 25 - n, field? If so, where can I get a quick intro/review of calculated fields basics so I understand how that works in the Power BI data view? (Should I move this question to the Dax forum?)
I think this requires only 2 columns for illustraction, ID and Over SLA. I want a column with TOTAL ID count and how many of them have OVER SLA = 1.
| ID | Over SLA |
| 1265 | 1 |
| 1850 | 1 |
| 1930 | 1 |
| 1942 | 1 |
| 1893 | 1 |
| 2105 | 1 |
| 2177 | 1 |
| 2204 | 1 |
| 2223 | 1 |
| 2313 | 1 |
| 2370 | 1 |
| 2396 | 1 |
| 2459 | 1 |
| 2461 | 1 |
| 2489 | 1 |
| 2500 | 1 |
| 2502 | 1 |
| 2507 | 1 |
| 2521 | 1 |
| 2523 | 1 |
| 2524 | 1 |
| 2526 | 1 |
| 2530 | 1 |
| 2531 | 1 |
| 2536 | 1 |
| 2539 | 1 |
| 2540 | 1 |
| 2542 | 1 |
| 2552 | 1 |
| 2558 | 1 |
| 2577 | 1 |
| 2580 | 1 |
| 2581 | 1 |
| 2584 | 1 |
| 2586 | 1 |
| 2587 | 1 |
| 2588 | 1 |
| 2589 | 1 |
| 2590 | 1 |
| 2595 | 1 |
| 2598 | 1 |
| 2600 | 1 |
| 2601 | 1 |
| 2607 | 1 |
| 2614 | 1 |
| 2616 | 1 |
| 2620 | 1 |
| 2621 | 1 |
| 2622 | 1 |
| 2624 | 1 |
| 2603 | 0 |
| 2626 | 1 |
| 2629 | 1 |
| 2631 | 1 |
| 2636 | 1 |
| 2637 | 1 |
| 2639 | 1 |
| 2640 | 1 |
| 2642 | 1 |
| 2643 | 1 |
| 2647 | 1 |
| 2650 | 1 |
| 2651 | 1 |
| 2652 | 1 |
| 2656 | 1 |
| 2658 | 1 |
| 2659 | 1 |
| 2660 | 1 |
| 2661 | 1 |
| 2662 | 1 |
| 2663 | 1 |
| 2665 | 1 |
| 2666 | 1 |
| 2667 | 1 |
| 2668 | 1 |
| 2669 | 1 |
| 2670 | 1 |
| 2671 | 1 |
| 2672 | 1 |
| 2673 | 1 |
| 2674 | 1 |
| 2675 | 1 |
| 2676 | 1 |
| 2677 | 1 |
| 2678 | 1 |
| 2679 | 1 |
| 2680 | 1 |
| 2681 | 1 |
| 2682 | 1 |
| 2683 | 1 |
| 2684 | 1 |
| 2685 | 1 |
| 2686 | 1 |
| 2687 | 1 |
| 2688 | 1 |
You are welcome. My solution will work in all versions. I have written 2 measures to solve the question (you can see them in the Fields pane of the image in my previous message).
3 Replies
You are welcome. My solution will work in all versions. I have written 2 measures to solve the question (you can see them in the Fields pane of the image in my previous message).