Forum Discussion
Add a constant line for 'Line & Clustered column chart' = Combo chart
Resident Rockstar
If your LINE Axis values are FIXED, you can calculate based on the position of the Bars, the correct Value of 5% to hard code (guessing around '5%Line = 80' or so based on the line axis) to fake this.... But if your Line Axis is variable based on the data selected, this work-around won't work.
OR... do you REALLY want to SUM all values of the LINE, then divide by the number of days, then divid by .05 to Calculate the true 5% mark compared to the Top Line? If there's possibily some true relation between the Bar and Lines?
FOrrest
In my case here, the 5% line is a "reference point" for the % values on Bar. - which is my primary Y-Axis. (left axis)
5% line has nothing to do with the other lines being plotted on 2nd Y-Axis (right axis).
- fhill
I don't recall if you said your right Axis was fixed or variable? If It's fixed, I created this measure
5%Line = 180
to approximate the 5% goal... This only works if the right Axis (Line #'s) are fixed (not based on a filter or selection), or you want to re-adjust this measure every time you update the report?
If it's variable, I have another idea to Calcuate the difference betewen the MAX and MIN % values shown (to determine the scale of the bars), then use 5% of that difference to MULTIPLY by the lowest LINE Value.... I'll try this next if the above work-around doesn't help...
Hi fhill,
thanks for your suggestion below. To create the calc line would work to provide "visual clues". However, the tooltip when you hover the cursor over it will not be accurate. Won't show 5% line.
Alternatively, to switch the data around, let the % be on the 2nd Y. Let me verify with product manager if this visual will be meaningful to user.
Appreciate your inputs! it's been very helpful to have other folks comment to verify I didn't miss any features available with this native chart.
- fhill
You are right about the Tool Tip for sure. If they decide they are OK it showing a fake value instead of '5%'. Here's the math to figure out your calculated line regardless of the values for Bars or Lines. ** HOWEVER, All Axis 'Start' values need to be set to 0! **
** P.S. I do things very broken apart to show my thoughts / steps... Feel Free to condense this into one Measure if wanted / needed. ** (Or can someone else do so for us?)
Max_Bar = CALCULATE( MAX('Table'[%]), ALLSELECTED() )5%Bar = [Max_Bar] / 0.05Max_LINE = CALCULATE(Max('Table'[Value]), ALLSELECTED() )Max_Line / 5%_Bar = [Max_LINE] * ( 1 / 'Table'[5%Bar])