Custom Visual

[Hussein_charif]

is there a custom visual like the Average pH visual below :

[danextian]

Hi @Hussein_charif 

You can use error bars but it is not going to be perfect. In the sreenshot below. I am using the same measure for the upper and lower bounds.

[Hussein_charif · Accepted solution]

hi @danextian @Uzi2019 ,

thank you guys for the help, i was able to achieve exactly the needed visual by using a constant reference line for the threshold, and used 2 calculated columns to get the white bars in the stacked bar chart, first calculated column is :
14 - 'table'[pH column]
Second is:
'table'[pH column] - 14

14 is the max ph level.
here is the result:


you then change the 2 calculated columns's colors to white and the main measure which is the average pH to green or whaever you desire

[Uzi2019]

Hi @Hussein_charif 

You can simply

1)add stack column chart 

2) add your PH column in Y axis

3) then go to analytics pane

4) add constant line

5) on Fx add your value. and set summarization to Average

that's it. you PH chart will be ready with few tricks to constant line

@Hussein_charif 

Match your average line color to background color

I hope I answered your question