Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I am creating statistiacal visual called a funnel plot (this is different than a funnel chart) in PowerBI using the R script feature. Each data point on the visual is associated with a unique ID called its' hco_id. What I need to do is show all the points on the visual while highlighting the point associated with the given hco_id on the visual in some way. There is a report level filter that filters for a specific hco_id at all times which is a problem since that means the visual will only show that one point instead of every single point. I've tried creating a seperate table in R that does not include the hco_id column but then this visual will show all the points but be unable to highlight the filtered hco_id's point. Below are screenshots showing what the visual and the report wide filter look like.
You need to use a disconnected table to feed your R visual, and add the filtered hco_id from your data model to the dataframe (as an additional column).
User | Count |
---|---|
99 | |
86 | |
78 | |
75 | |
71 |
User | Count |
---|---|
112 | |
105 | |
96 | |
74 | |
66 |