Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Help Changing Funnel Plot Colors and Shapes of Specific Data Points

I just starting creating Funnel Plots for Medical Center data where I plot Regions or Facilities. 

I use a count as 'Occurrence' and PBI create the Ratios.  Can someone help with these issues?

1) How can I see the values that are created for the Y-axis Ratio for each plot?

2a) How can I see what PBI calculates as the Upper & Lower Confidence Limits?  I specifically want to know what the 2nd CL is that I set at 99.5%.

2b) These 99.5% CL values are needed because I want to change the color of the circle to RED if the plot (Facility or Region) falls Above the Upper 99.5% CL, and change to GREEN if the plot falls Below the Lower 95.5% CL.  Can you tell me if & how to do this?

3) How can I change the SHAPE from circle to Triangle or a Diamond just for ONE plot (Facility or Region) ? 

SAS is able to do this with this syntax: "markerattrs=(symbol=diamondfilled)"

Thanks,

Craig

7 Replies

  • v-evelk's avatar
    v-evelk
    Microsoft Employee

    Hello,

     

    1) How can I see the values that are created for the Y-axis Ratio for each plot?

    -- The exact position is calculated by R script and in fact Y value doesn't have sense for the current chart as I understand, only the position is important

     

    2a) How can I see what PBI calculates as the Upper & Lower Confidence Limits?  I specifically want to know what the 2nd CL is that I set at 99.5%.

    -- It is calculated by algorythm from R script but R script is out of my experstise, unfortunately. However, I believe that there is some correlation that is based on data themselves only.

     

    2b) These 99.5% CL values are needed because I want to change the color of the circle to RED if the plot (Facility or Region) falls Above the Upper 99.5% CL, and change to GREEN if the plot falls Below the Lower 95.5% CL.  Can you tell me if & how to do this?

    -- As I found, current implementation of the chart doesn't allow to do it. There are two option to solve this issue: to fork visual and adjust to you needs or describe the issue with details and screens and I will register it as a future request for the visual and will send it to an appropriate developer.

     

    3) How can I change the SHAPE from circle to Triangle or a Diamond just for ONE plot (Facility or Region) ? 

    -- The same recommendation as for 2b)

     

    Kind Regards,

    Evgenii Elkin,
    Software Engineer
    Microsoft Power BI Custom Visuals
    [email protected]

    • Anonymous's avatar
      Anonymous
      Not applicable

      Evgenii, I just sent you an email directly since I attached an Excel sheet as an example of the my request.

      Thanks!

      • v-evelk's avatar
        v-evelk
        Microsoft Employee

        Hello Craig,

         

        Thank you for the detailed description.

        I have added a couple of feature requests concerning color and shapes of points into a visual backlog.

        Unfortunately, I cannot provide any ETA regarding these features implementation.

         

        Kind Regards,

        Evgenii Elkin,
        Software Engineer
        Microsoft Power BI Custom Visuals
        [email protected]