Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Static Line Chart

Hello Guys

In the graph below there is a static line where I can compare "Italy" against other countries by selecting in the dropbox. Anyone knows how to do it?

 

Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

    We can create a measure like that to work on it.

     

    LINE =
IF ( MAX ( yourtable[country] ) = "Italy", 100, [measure] )

     

3 Replies

  • parry2k's avatar
    parry2k
    Super User
    6 years ago

    Anonymous you can add a measure with static line value you want

     

    Static Line = 100

     

    I would 💖 Kudos 🙂 if my solution helped. If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hello 

      Thanks for your help

      For this line chart, there are different values across the months where each individual month has its own value. Is there a kind of Dax formula that isolates "Italy" making it statistic and other lines not?

      See the dashboard below

      https://corona.dataclue.bi/desktop/

      • v-frfei-msft's avatar
        v-frfei-msft
        Community Support
        6 years ago

        Hi Anonymous ,

         

        We can create a measure like that to work on it.

         

        LINE =
IF ( MAX ( yourtable[country] ) = "Italy", 100, [measure] )