Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I send to you, across the time and space the separate us, a cordial greeting.
I will attempt to state my inquiry briefly: I would like to pass both filtered and unfiltered data to an R script visual.
Let me attempt to demonstrate my difficulty. Consider the R code below:
Observe that the visualization uses both filtered and unfiltered data: The boxplot uses all the data points in the data set, but the red line uses only one data point.
The problem is that, in Power BI, when I use a slicer to select the name, I lose access to the unfiltered dataset.
I was able to develop a work around by loading the dataset with each call of the R script. See below:
I feel this solution is inelegant, as there's the performance hit of loading the data set each time the slicer changes. Besides, users aren't going to be able to deal with this state of affairs.
I was reading that Dax has a function ALL(), which I think is analagous to what I need.
Any thoughts?
Solved! Go to Solution.
Your probem is that you cannot feed more than one set of columns/measures (unfortunately called "dataset" - better called a dataframe) into the R visual. You can decide if your dataset is affected by the filter context or not, but you can't have both.
Your probem is that you cannot feed more than one set of columns/measures (unfortunately called "dataset" - better called a dataframe) into the R visual. You can decide if your dataset is affected by the filter context or not, but you can't have both.
I think Ibendlin is right.
For the sake of experimentation, I tried retrieving the non-filtered data from a SQL database, reasoning that with SQL I can retrieve only the field I want instead of loading the whole dataset. Performance was no better.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
147 | |
109 | |
107 | |
85 | |
63 |