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 f...
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

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