Forum Discussion
Histogram with threshold/constant line on x-axis
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
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.
2 Replies
- v-easonf-msft
Community Support
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. - AnonymousNot applicable
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