Forum Discussion

bilogin's avatar
bilogin
Icon for Helper I rankHelper I
6 years ago
Solved

Percentage passed SLA

Hi all,   Thanks in advance for your help on this, I'm a BI noob and it's taken me a few days to get this far!    So through Excel and our CRM, there is a bar and line chart that shows the volume...
Need Help
  • tex628's avatar
    tex628
    6 years ago

    I'm assuming that the values displayed in the last image is the "Passing" percentage. In that case create a measure like this:

    Measure =
DIVIDE(
CALCULATE( COUNTROWS(ContactReport) ; ContactReport[Pass/Fail] = "Pass") ;
COUNTROWS(ContactReport) ;
BLANK()
)


    Format the measure as % and then place it in your chart and remove the legend. There should only be the measure and the date dimension. 

    If you dont get the correct result post a picture and we'll take another look 🙂 

    Br,
    J

tex628's avatar
tex628
Icon for Community Champion rankCommunity Champion
6 years ago

Hi,

The "100% stacked column chart" should display the values in % if you turn on the datalabels. 

If you post a picture of your current chart it might be easier to see whats wrong! 

Br,
J

bilogin's avatar
bilogin
Icon for Helper I rankHelper I
6 years ago

 

  • bilogin's avatar
    bilogin
    Icon for Helper I rankHelper I
    6 years ago

    This is how I want it to look:

     

     

    Thanks,

    Bec

    • tex628's avatar
      tex628
      Icon for Community Champion rankCommunity Champion
      6 years ago

      I'm assuming that the values displayed in the last image is the "Passing" percentage. In that case create a measure like this:

      Measure =
DIVIDE(
CALCULATE( COUNTROWS(ContactReport) ; ContactReport[Pass/Fail] = "Pass") ;
COUNTROWS(ContactReport) ;
BLANK()
)


      Format the measure as % and then place it in your chart and remove the legend. There should only be the measure and the date dimension. 

      If you dont get the correct result post a picture and we'll take another look 🙂 

      Br,
      J

      • bilogin's avatar
        bilogin
        Icon for Helper I rankHelper I
        6 years ago

        Success!

         

        Thank you tex628