How to use Top and Bottom Quartile Values as Error Bars in a Line Chart

[Anonymous]

Dear Forum Friends,

I have a data file with a list of Healthcare measures and their indicators as well as the median values, bottom and top quartile values of each indicator (see top table in screenshot below).

I woul dlike to visualize the median as well as the bottome and top quartile values in a line chart, but would like the top and bottom quartile as as an error bar for the median values.

However, the error bars for the median of each indicator shows the SAME quartile value. As in the screenshot I below, the top quartile value for an indicator seems to be the average of all quartile values across the measurs/indicators. It is not showing the specific top quartile value of each indicater. 

Is there anyway to stop error bar values from being agregated? Or it there any DAX measure that can be used? 

Thanks in advance for your suggestions/ advice.

[lbendlin]

Please do not use line charts for independent subjects.  Use Box and Whiskers - they come with built in UCL and LCL

[Anonymous]

Thanks for your reply. There are 2 box and whisker visual power BI apps that I downloaded. But they have the value for median, but they don't allow FIXed values for whiskier values. My data file has already the median, bottom and upper quartile values for each record (a list of measures/indicators). I just want to show the 3 values in an visual just like in an error bar.  

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[Anonymous]

Thanks. I pasted some data in the Excel table. It has measures, indicators, median, top quartile and bottom quartile values. I would like to have Measures(Indicators) in the X axis, with Median in Y, and Bottom and Top Quartile value shown as the Error Bar value for each median value.  

Measures	Indicators	Median	Botton Quartile	Top Quartile
Measure 1	Indicator 1	62.2	56.8	67.1
Measure 1	Indicator 2	58.8	54.6	64
Measure 1	Indicator 3	41.8	35.4	46.1
Measure 1	Indicator 4	13.3	16	9.7
Measure 1	Indicator 5	77.1	74.2	78.5
Measure 1	Indicator 6	23.8	15.5	29
Measure 1	Indicator 7	15.5	10.9	19.1
Measure 1	Indicator 8	10.6	6	16.3
Measure 1	Indicator 9	52.5	42.9	63.5
Measure 2	Indicator 10	38.9	29.2	52.6
Measure 2	Indicator 11	72.7	63.6	76.9
Measure 2	Indicator 12	54.6	46.2	65.4
Measure 2	Indicator 13	54.5	48.3	64.9
Measure 2	Indicator 14	33.9	28.6	43.3
Measure 2	Indicator 15	70.4	62.1	79.6
Measure 2	Indicator 16	47.9	40.1	57.5
Measure 2	Indicator 17	43	36.4	49.4
Measure 2	Indicator 18	54.1	45.1	59.5
Measure 2	Indicator 19	42.1	39.2	45.5
Measure 3	Indicator 20	12.2	8.1	14.4
Measure 3	Indicator 21	43.4	41	47.7
Measure 3	Indicator 22	15.8	10.5	18.5
Measure 3	Indicator 23	56.6	50.1	64.6
Measure 3	Indicator 24	29.5	17.5	37.4
Measure 3	Indicator 25	41.3	36.9	44.8
Measure 3	Indicator 26	11	7.9	15.1
Measure 4	Indicator 27	72.6	64.6	74.4
Measure 4	Indicator 28	44.2	40.5	49.3
Measure 4	Indicator 29	49.9	46.1	57.7
Measure 4	Indicator 30	33.2	27.3	41.5
Measure 4	Indicator 31	52.4	47.6	58.2
Measure 4	Indicator 32	35.3	28.6	41.9
Measure 4	Indicator 33	62.6	58.6	67.2
Measure 4	Indicator 34	6.7	9	3.2
Measure 4	Indicator 35	56.2	51.6	71