Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
I used to have a clustered column chart to show the median of a value for different categories with a dynamic target constant line using a measure added to the Constant Line option in Analytics. To visualize the number of values in each category I had a second clustered column chart below to display the value count. (See first print screen below or first page in sample pbix).
Now I would like to show the median and count of values in the same chart together with the constant line. I want this mainly to access the count of values for filtering (hiding categories having too few values).
If I use a "line and clustered column chart" I could add the count of values as a line and the target value as a line (because it is a measure), but I would like the target value line to use the first axis as it is related to the values (<1.0) and the count of values to use a secondary axis (>>1). Now all lines are on the secondary axis (Y-axis Line) and all column values are on the first axis. (See second print screen below or second page in sample pbix).
Any idea on how I could choose axis for the constant line or solve this anyhow.
Sample pbix can be found here and print screens below.
Two charts - one with median of values + constant line, one with count of values. Cannot access Count of values for filtering the upper chart (?)
1 combo chart, but both lines (target value and count of values on same axis as both are lines). Visualization of target value is thus of no use.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 79 | |
| 38 | |
| 31 | |
| 27 | |
| 27 |