Forum Discussion
Line at axis X
- Anonymous4 years ago
Hi Anonymous ,
According to your screenshot, I think you should use Line and clustered column chart to create a visual. It supports us to use "X-Axis Constant Line" in Analysis Pane.
Here is my Sample, data table Table1 and Table2 which is a calculated table with selections.
Table 2 = {"Contagem","Belo Horizonte","Campinas"}Measure:
Measure = VAR _SELECTVALUE = SELECTEDVALUE('Table 2'[Value]) RETURN IF(_SELECTVALUE = "Contagem",TIME(21,0,0),IF( _SELECTVALUE IN {"Belo Horizonte","Campinas"},TIME(15,0,0)) )You may refer to the offical blog which is shared by amitchandak to add this measure into "X-Axis Constant Line" in Analysis Pane.
Result is as below.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
According to your screenshot, I think you should use Line and clustered column chart to create a visual. It supports us to use "X-Axis Constant Line" in Analysis Pane.
Here is my Sample, data table Table1 and Table2 which is a calculated table with selections.
Table 2 = {"Contagem","Belo Horizonte","Campinas"}
Measure:
Measure =
VAR _SELECTVALUE = SELECTEDVALUE('Table 2'[Value])
RETURN
IF(_SELECTVALUE = "Contagem",TIME(21,0,0),IF( _SELECTVALUE IN {"Belo Horizonte","Campinas"},TIME(15,0,0))
)
You may refer to the offical blog which is shared by amitchandak to add this measure into "X-Axis Constant Line" in Analysis Pane.
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.