Convert matrix to Line chart visual

[TomSinAA]

I have a matrix visual that displays True and False counts as a  % by Month.

However when a convert it to a Line Chart visual the percentages are not by month but for the overall time period for the entire chart

How do I get the line chart to show the correct percentage for each month.

[DivkLearner · Accepted solution]

Hello @TomSinAA 

I just followed the same example. I was able to get the following:

using the Measure:

1. For False : 

% Followup No =

  DIVIDE(

    CALCULATE( COUNTROWS(Sheet1), Sheet1[Decision]="No"),

    COUNTROWS(Sheet1)

  )

2. For True:

% Followup Yes =

  DIVIDE(

    CALCULATE( COUNTROWS(Sheet1), Sheet1[Decision]="Yes"),

    COUNTROWS(Sheet1)

  )

Visualization for the Line Chart. 

Best regards,
DivKlearner – A Bit Forward Daily
Join us as we explore and learn IT together.
Discover simplified IT learning on YouTube