Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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
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
pbicvsupport@microsoft.com
Evgenii, I just sent you an email directly since I attached an Excel sheet as an example of the my request.
Thanks!
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
pbicvsupport@microsoft.com
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:
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
pbicvsupport@microsoft.com
Evgenii Elkin,
Software Engineer
Microsoft Power BI Custom Visuals
pbicvsupport@microsoft.com