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] )

     

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] )