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.
Anonymous , You can create a measure using Switch, and then you can have those values. You can use that under X-axis Constant line under fx(Analytic Pane). But please note that is only supported for a few data types