Forum Discussion

boboroo's avatar
boboroo
Frequent Visitor
4 years ago

R custom Visual Filter and Interactions

Hi everyone, currently, the standard visuals and custom visuals in the store do not meet the requirements of my internal customer. I looked around and found out, that we can build custom visuals v...
Need Help
V-lianl-msft's avatar
V-lianl-msft
Community Support
4 years ago

Hi boboroo ,

 

1.The calculated column is static, while the measure is dynamic, so the measure cannot be referenced correctly in the calculated column.

Please change this calculated column to a measure. If you need to be used as a slicer, you need to create the correct calculated column. Please do not reference the measure in the calculated column.

 

2.MS only provide APIs to support these operations for TypeScript visuals, and not for R. 

You may try to package R Code into Power BI Custom Visual.

https://docs.microsoft.com/en-us/power-bi/developer/visuals/funnel-plot-from-r#create-an-r-powered-visual-and-package-in-r-code 

https://towardsdatascience.com/interactive-power-bi-custom-visuals-with-r-a6a4ac998710 

 

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

MARKZI's avatar
MARKZI
Frequent Visitor
3 years ago

Could you please give an example on how to do what you described in point 2? I have some R Code that i package to a visual exactly following the way described by the link you provided but even with a build custom R Visual and even after changing the configuration files to accept filters (from the IFilter documentary MS support site) it will not filter my other native visuals to whatever i select in R Custom Visuals (i use R plotly as main library). If needed i can share my project.

  • andrjohns's avatar
    andrjohns
    Helper II
    3 years ago

    The R-Based custom visual can't filter/highlight other visuals unfortunately. This can only be done using the standard custom visuals