Looking to create a Span Chart on Power BI. What's the best way to do so?

[mj1996]

Currently use a span chart updated manually on Excel to track percentiles along with other statistics (median, STD, etc.) -- looking to replicate this in Power BI so it's automatically updates. 

screenshot attached for reference. 

[v-shex-msft]

Hi @mj1996 ,

Power bi not allow you to create this chart, maybe you can try to create calculated table based on raw table records.

Calculated Table = 
UNION (
    ROW ( "Calculate", "Median", "Result", MEDIANX ( 'Sample', 'Sample'[Amount] ) ),
    ROW ( "Calculate", "STD", "Result", STDEVX.S ( 'Sample', 'Sample'[Amount] ) ),
    ROW ( "Calculate", "Total", "Result", SUMX ( 'Sample', 'Sample'[Amount] ) )
)

Above table result will change based on sample table records.

Regards,

Xiaoxin Sheng