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
      • v-evelk's avatar
        v-evelk
        Icon for Microsoft Employee rankMicrosoft Employee
        6 years ago

        The thread has been continued in e-mail...

        I am just publishing here the answer to see a full picture.

         

        "There is a file pbiviz.json inside the project folder.

        You should edit it and change 5th string where you can see visual GUID.

        You should just put here a set of chars and digits, actually, it doesn’t matter what exactly, but would be better if it was corresponding to the visual name.

        For instance, it may be something as following

        RHTML_FUNNEL_CUSTOM_578345975

         

        Regarding ETA, unfortunately I cannot provide a better one."

         

        Kind Regards,

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