1.Dnd a dimension in Columns deck.
2.Dnd a measure in Rows deck.
3.Right click on axis of chart & select Add reference line option.
Switch to Band tab
Select Per cell option.
Select create parameter option from value field of 'band from' pane.
In create parameter window keep default settings as it is & click on OK.
In reference line window click on OK.
Reference line is displayed.
4.Right click on measure field in Rows deck & select Add table calculation option.
In add table calculation window keep default settings as it is & click on OK.
OR
Open attached 14078.vizx
GO to Scenario1 sheet
Actual result: Reference line is displayed but label for parameter is not displayed at appropriate position.
Expected result: Reference line label for parameter should be displayed at appropriate position.
Scenario 2:
1.Dnd a dimension in Columns deck
2.Dnd 2 measures in Rows deck
3.Click on Axes deck & select Merged axes->Clustered option.
4.Right click on first measure field in rows deck & select Add table calculation option.
In add table calculation window keep default settings as it is & click on OK.
5.Right click on second measure field in rows deck & select Add table calculation option.
In add table calculation window keep default settings as it is & click on OK.
6.Right click on axis of chart & select Add reference line option.
Switch to Band tab
Select Per cell option.
Select create parameter option from Value field of 'Band from' pane.
In create parameter window keep default settings as it is & click on OK.
In reference line window click on OK.
OR
Open attached 14078.vizx
Go to Scenario2 sheet
Actual result: Reference line label for parameter is not displayed at appropriate position.
Observation: This only happens in case of parameters.
This only happens for Band reference line.
This happens for 'Per cell' scope only.
This issue occurs for dual axis chart also.
Labels are displayed properly on swapping rows & columns(i.e for Horizontal bar chart.)
Broken build: 17-rc-51
![]() |
352 KB
|
253 KB
![]() |
352 KB
|
87 KB
![]() |
335 KB
|
61 KB
![]() |
334 KB
|
51 KB
This is expected behavior b/c the category has no value (null).
Consider below scenario also:
Dnd a dimension in columns deck.
Dnd a measure in Rows deck.
Open add reference line window from axis of chart.
Select Per cell scope.
Select Constant option from aggregate function list.
Click on OK.
Right click on measure field & select Add table calculation option.
Keep default settings as it is & click on OK.
OR
Open attached 14078_scenario2.vizx
Actual result: You will observe that reference line label for constant value is not displayed at appropriate position.
Expected result: Reference line label should be displayed properly on reference line.
Consider below scenario also:
Dnd a dimension in columns deck.
Dnd a measure in Rows deck.
Open add reference line window from axis of chart.
Select Per cell scope.
Select Constant option from aggregate function list.
Click on OK.
Right click on measure field & select Add table calculation option.
Keep default settings as it is & click on OK.
OR
Open attached 14078_scenario2.vizx
Actual result: You will observe that reference line label for constant value is not displayed at appropriate position.
Expected result: Reference line label should be displayed properly on reference line.
Verified in dev-44.Refer attachment(14078_v18.png,14078_v18.vizx)
Verified in dev-44.Refer attachment(14078_v18.png,14078_v18.vizx)
Issue #14078 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build 18-dev-40 |
No time estimate |
This is expected behavior b/c the category has no value (null).