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 need stay at 9 PM,  if I select Belo Horizonte or Campinas the line need be at 3 PM.

Need Help
  • 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.

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    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.

  • amitchandak's avatar
    amitchandak
    Super User
    4 years ago

    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