Histogram with threshold/constant line on x-axis

[Anonymous]

Hi all,

I want to plot a histogram an add thresholds (constat lines) for the histogram. That is so far possible for the numerical value on the y-axis but not yet supported for the x-axis.

I have a dataset that shows values between [0;100]. Imagine, I want to set a constant line at 25 and at 75. Thus, I would add upon the bins further 3 intervals, namely [0;25], [26;75];[76;100]

Thus, my questions:

• Can I create thresholds/a constant line on a histogram for the x-axis? If yes, can I do it without a custom visual? If not, which custom visual currently available supports this functionality?
• Can I further identify how many items are with each new interval? So that I have either a % value or an absolute value of X items in [0;25], Y items in [26:75], and Z items in [76;100].

Thank you for suggestions and  best regards,

Conny

[Anonymous]

Thank you @v-easonf-msft for your support!

The last link (using shapes) helped me to create the vertical lines as desired.

Best regards,

Conny

[v-easonf-msft · Accepted solution]

Hi , @Anonymous 

You can check if the solutions in these threads work for you.

https://community.powerbi.com/t5/Desktop/Bucketing-in-Histogram/m-p/1366606 

https://community.powerbi.com/t5/Desktop/Unknown-value-in-histogram/m-p/1290564 

If possible,have you tried to use shapes to  create thresholds/a constant line on a histogram.

https://community.powerbi.com/t5/Desktop/Reference-Line-on-x-axis/m-p/91356 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.