Forum Discussion
Helper IVPareto without Bars?
It is indeed relatively complex, so I will provide an actual working example.
I downloaded the .pbix from this article and created a new Axis table and a new measure:
Bucket Sales = VAR BucketMin = SELECTEDVALUE ( 'Axis'[Value] ) VAR BucketMax = CALCULATE ( MIN ( 'Axis'[Value] ), 'Axis'[Value] > BucketMin ) VAR NonZeroProducts = FILTER ( VALUES ( Products[ProductKey] ), [Total Sales] > 0 ) VAR NonZeroCount = COUNTROWS ( NonZeroProducts ) VAR Summary = ADDCOLUMNS ( NonZeroProducts, "@Rank%", DIVIDE ( RANKX ( NonZeroProducts, [Total Sales] ), NonZeroCount ) ) VAR BucketSum = SUMX ( FILTER ( Summary, [@Rank%] >= BucketMin && [@Rank%] < BucketMax ), [Total Sales] ) RETURN DIVIDE ( BucketSum, NonZeroCount )The result looks like this:
See the attached modified file.
Super UserYou'll need to define a new dimension table to use on your x-axis and then write your measures to read this value as the percent to use.
Axis = GENERATESERIES ( 0, 1, 0.01 )
Here's a simple example showing how to use a parameter table in a measure:
https://stackoverflow.com/questions/56956190/how-to-use-a-measure-as-an-axis-in-power-bi
ThigsI'm still a little confused. I made the Axis table, but I'm confused where to change the axis in my formula. Since my SKUs are not currently done by percent, will I need to make a new column where they are done by percent?
- AlexisOlson
It is indeed relatively complex, so I will provide an actual working example.
I downloaded the .pbix from this article and created a new Axis table and a new measure:
Bucket Sales = VAR BucketMin = SELECTEDVALUE ( 'Axis'[Value] ) VAR BucketMax = CALCULATE ( MIN ( 'Axis'[Value] ), 'Axis'[Value] > BucketMin ) VAR NonZeroProducts = FILTER ( VALUES ( Products[ProductKey] ), [Total Sales] > 0 ) VAR NonZeroCount = COUNTROWS ( NonZeroProducts ) VAR Summary = ADDCOLUMNS ( NonZeroProducts, "@Rank%", DIVIDE ( RANKX ( NonZeroProducts, [Total Sales] ), NonZeroCount ) ) VAR BucketSum = SUMX ( FILTER ( Summary, [@Rank%] >= BucketMin && [@Rank%] < BucketMax ), [Total Sales] ) RETURN DIVIDE ( BucketSum, NonZeroCount )The result looks like this:
See the attached modified file.
- Thigs
This is very helpful, thank you!
I am clearly messing something up. I replaced the values in the formula with my own, and I'm getting the following graph.