Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Line at axis X

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 ne...
  • Anonymous's avatar
    Anonymous
    4 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 Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.