Forum Discussion

guyinazo's avatar
guyinazo
Icon for Helper I rankHelper I
5 years ago

Trying to understand Pareto charting

I thought I had all of the sytax in my DAX statement correct to create a Pareto visual, but maybe I am not understanding how to get the line to max at 100 and not its current max value (unless there is a setting in the bar/line chart I am missing).

 

Here is the chart and DAX.  Thanks for any advice

The ChartThe DAX

Need Help

1 Reply

  • ryan_mayu's avatar
    ryan_mayu
    Icon for Super User rankSuper User
    5 years ago

    guyinazo 

    it's better to share some sample data.

    maybe you can try this

    PROPORTION=sum(value)/

    CALCULATE(SUM('Table'[value]),ALL('Table'))
     
    Acculumate=
    P2 =
    var _PROPORTION=[PROPORTION]
    RETURN CALCULATE([PROPORTION],FILTER(ALL('VSR Selected Reasons'[BarrierID]),[PROPORTION]>=_PROPORTION))