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) H...
color
funnel plots
shape
v-evelk's avatar
v-evelk
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

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
    7 years ago

    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
      Icon for Microsoft Employee rankMicrosoft Employee
      7 years ago

      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]

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        Evgenii & team (I emailed this directly the other day)

         

        Could you elaborate on #2 below?  Where is the path for this?

        "guid": "RHTML_FUNNEL_978302916642"

        And what should we change it to?

         And if we cannot implement on our end, could you give a better ETA for the Developer to implement these changes?

         

        Thanks!

        _________________________________________

        To build the visual with your changes you have to:

        1. Clone the repo
        2. Change GUID inside pbiviz.json file (otherwise visual will refer to an original visual from CDN)
        3. Run “npm install” in the root of the repo (You have to install Node.JS to have an ability to perform npm commands)
        4. Run “npm run package” in the root of the repo to build PBIVIZ package that you can find then in DIST folder
        5. Import PBIVIZ package in PowerBI from the file