Stacked Column Chart visual advise
Hi all, I need help with a Stacked Column Chart. Currently, I’m displaying three categories on the Y-axis against the X-axis for the current quarter, and the data is showing correctly. I want to add a bar for the prior quarter using the same Y-axis and X-axis but am unable to achieve this. Can anyone advise? This is what i have Ideally, this is what i want to achieve
100% stacked column chart - labels issue
Hi all, I hope maybe you will be able to help me. Looked for solution here but haven't found it. The issue I have is that I am creating 100% stacked column chart, and had to add labels - unfortunately sometimes these categories in legend get just few % (less than 5% like orange one below in the middle) and these labels are not visible. Tried different ways to fix this: made this as large as possible (these Month x-axis category could have more so we would have more columns there), turned on overflow text for labels, but cannot force them to be visible for all values, even 0.1% - for stacked chart I don't see option to move labels outside of the bars which might do the trick. Have anyone had same issue or have an idea how to solve this? Here is the link to pbix with dummy data as I can't share real dataset for that. There same issue is shown as it does not display label for all the categories in legend Appreciate any help 🙂 Thanks, Piotr
The workaround of using the measure as axis in the visual
For Power BI users, a problem often encountered is that they want to put the measure on the axis, but find that it cannot be achieved. Especially beginners want to do this habitually. Below I will give an example to explain this problem. Basic situation: After a period of merchandise sales, a group of sales representatives will face performance evaluation.
Dax help for measure on stacked column chart that's filtered
Hi PBI RS Army, I am seeking guidance on something that seems like it should be simple but is proving to be challenging: I have a stacked column chart showing sales of various items of winter apparel by region (N, S, E, W) Some items (like gloves) are sold in all regions (this is completely fabricated sample data). I have two slicers: 1. Category = gloves 2. Region = only East and North (excluding West) I also have a tooltip tab that pops up when hovering over any of the elements of the stacked column chart as shown: The challenge I'm having is getting the measure (sum of sales measure) to reveal the sum of east region + north region (only) on the tooltip which is shown when hovering over either of the East or North region segments of any of the years. My formula for that measure is: sum of sales measure = CALCULATE(SUM(DATA[SALES]), REMOVEFILTERS(DATA[REGION])) Because I have the removefilters(data[region]) in the filters portion of the dax, it includes all three regions (including West). But of course if I remove that removefilters(data[region]) portion from the measure, it'll only show the sum of sales for the region over which I'm hovering. Any guidance appreciated.
Legend and Stacked column both in same order..has this been solved
The Column is sorting with first name in Legend on the bottom and last Name on top. Is there a way to have it sort with last name on bottom of stack and first name on top for better readability? I've tried things from other posts, but nothing works. I also saw to vote for feature, but looks like this request has been out there for years with no progress. Please help out a girl. 🙂
Create miscellaneous/other group using count below a threshold
I've got a Line and Stacked Column Chart (using this because of Pareto line). I used to create a measure "Count". Count = CALCULATE ( COUNTROWS ( Projects ), ALLSELECTED ( Projects ), VALUES ( Projects[Points] ) ) "Project[Points]" is the Shared axis and "Count" is the Column values. Now I want to use this measure and combine any calculated values below 3 into a miscellaneous/other group. So it would be removing "M" thru "g", and creating an "other", stacking them all together. I've been using power bi for about 2 months now. So the more steps explained the better. Thank you.Date slicer - Max period multi select not updating Stacked Column chart
I have the following (simplified) stacked column chart which counts the number of issues per source: Based on this (simplified) data: I then apply a date slicer which allows multiple selections The date slicer is joined in the model and works correctly by adjusting the number of issues if one month is selected at a time. When multiple months are selected then it need only evaluate the most recent month which I have calculated with the following 2 measures: MaxPeriod = CALCULATE ( MAX ( vw_DimDate[Month] )) IsMaxPeriod = IF(NOT(ISBLANK([MaxPeriod])), IF( MAX ( vw_PBI_MR_IssuesByAct[Period] ) = [MaxPeriod], 1, 0 )) Confirmed to be working with a table visual: If I then apply this filter, the table visual shows the correct count of 39 for the period of 202006 The problem is that the stacked bar chart does not-it shows 70 issues rather than 39 for 202006-any ideas on how to solve this?
