Forum Discussion

Zakaria_1980's avatar
Zakaria_1980
Post Patron
6 years ago

Line stype in the graph

Hello,   please I need that the curve in green whenevr it is before the bar chart the type of the line is solid and when it is after the bar chart the type of the line should be a dotted line. beca...
Need Help
v-lili6-msft's avatar
v-lili6-msft
Community Support
6 years ago

hi  Zakaria_1980 

You could split the green line measure into two measure, then set line type separately.

for example:

Green measure 1=IF(MAX('Date'[Date])<=MAX('20W33'[Date]),[green line measure])

Green measure 2=IF(MAX('Date'[Date])>=MAX('20W33'[Date]),[green line measure])

 

Then use Green measure 1  and Green measure 2  in the line chart instead of green line measure. Now do formatting for these two new measure.

 

Regards,

Lin

  • Zakaria_1980's avatar
    Zakaria_1980
    Post Patron
    6 years ago

    for the green line i don't have a measure but a column which is calculating the cumulative of my data

     

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

      hi Zakaria_1980 

      Could you please share your sample pbix file for us have a test, that will be a great help.

       

      Regards,

      Lin

    • AllisonKennedy's avatar
      AllisonKennedy
      Community Champion
      6 years ago
      Zakaria_1980 what are the names of your columns and tables please?
      • Zakaria_1980's avatar
        Zakaria_1980
        Post Patron
        6 years ago

        Table name: STC_Deploy Progress

        Column that calculate cumulative of the green line: cumulative. ACT+ FCT

         

         

        for the red bar chart i've already shared the measure that i've used + column with formula that i've used.

         

        br,