Market Share Percent In Ribbon Chart - % Of Column Total
We are trying to mimic The 100% stacked bar chart's % of column total calculation on a ribbon chart. So essentially a market share % of total calculation for each date we have. We've tried creating a measure that we thought would work but it has not: AllDivisionTracking := CALCULATE ( [TrackingNumbers], ALL ( Divisions ) ) PercentOfTotal := DIVIDE ( [TrackingNumbers], [AllDivisionTracking] ) This measure does not seem to work when inserted as the measure on a ribbon chart. The ribbon chart seems to make this calculation over the entire date range instead of limiting it to each day as we would have expected.
Stacked Column Chart Help with % Count
Hi, I have a measure that gives the percentage of on time deliveries we make for each customer with the following formula (Difot Monthly % = divide(sum(Difot[Difot Pass Count]),sum(Difot[Difot Count])) eg Im trying to think of a formula to give the count of how many customers would fall into each braket such as difot <50%, 50 - 60%, 70-80%, etc up to 100% so I can create a stacked column chart and show by month. The Above is a manual upload that wont change with the new month I have tried the following <50% = COUNTROWS(filter(Difot,DIVIDE(sum(Difot[Difot Pass Count]),sum(Difot[Difot Count]))<=50)) but it returns the number of rows. But i realise I want to count how many customers fall into each bracket which I haven't been able to include. Any ideas? Thanks in advance, EamGCreate a timeline view using the Stacked Bar Chart Visualiztion
Hopefully there's a Datanaut out there that can help. I can, and have, for years been able to create time line views in Excel Charts using a Bar chart like so: In Power BI, I have an ask to create a view just like this. Our organzational security FORBIDS the use of 3rd party custom visuals so that is not a solution. This is the closest I have been able to come: I am so close I can taste it, but cannot figure a way to first, make the axis values convert from the numeric format into date format, and then second, set it so these are monthly values, not every 50 days. Anyone that wants a big Kudos from me that has a solution to this one, let me know! Warmest Thanks in advance
