Forum Discussion

TomSinAA's avatar
TomSinAA
Helper IV
1 year ago
Solved

Convert matrix to Line chart visual

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.

Need Help
  • DivkLearner's avatar
    DivkLearner
    1 year ago

    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

1 Reply

  • DivkLearner's avatar
    DivkLearner
    Resolver I
    1 year ago

    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