Forum Discussion
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-evelkMicrosoft 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]- AnonymousNot applicable
Evgenii, I just sent you an email directly since I attached an Excel sheet as an example of the my request.
Thanks!
- v-evelkMicrosoft 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]