Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
Solved! Go to Solution.
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).
Hi,
You may download my PBI file from here.
Hope this helps.
Hi Ashish,
Thank you, but I have an older version of PowerBI. I can't see how to got these results. If you created a new calculated variable I couldn't see it.
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).
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
68 |
User | Count |
---|---|
226 | |
129 | |
120 | |
84 | |
78 |