Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Conditionally Format lines on a line graph

Hi, I would like to conditionally format my lines in the below line graph using year in DAX. The logic that I want is if year= 2019-2020, I would like the lines to be shown as dashed (--) instead of ...
Need Help
  • v-yadongf-msft's avatar
    v-yadongf-msft
    3 years ago

    Hi Anonymous ,

     

    Maybe this is the result you want:

    Please try following DAX:

    Measure = CALCULATE(SUM('Table'[Values]),FILTER('Table','Table'[Year] IN {2019,2020}))

     

    Put the [measure] and [Value]  into Y-axis:

     

    Change line type of measure into dashed:

    Best regards,

    Yadong Fang

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

     

v-yadongf-msft's avatar
v-yadongf-msft
Community Support
3 years ago

Hi Anonymous ,

 

Maybe this is the result you want:

Please try following DAX:

Measure = CALCULATE(SUM('Table'[Values]),FILTER('Table','Table'[Year] IN {2019,2020}))

 

Put the [measure] and [Value]  into Y-axis:

 

Change line type of measure into dashed:

Best regards,

Yadong Fang

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