Line at axis X

[Anonymous]

Hi Guys

Someone can help me with this situation?

I need put one flexible line on the axis X, my axi X is made of hours, I would like to put one line.  If I select Contagem on the box , this line need stay at 9 PM,  if I select Belo Horizonte or Campinas the line need be at 3 PM.

[Anonymous · Accepted solution]

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.

[amitchandak]

@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