Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
User | Count |
---|---|
93 | |
83 | |
77 | |
72 | |
65 |
User | Count |
---|---|
114 | |
101 | |
96 | |
65 | |
60 |