BI Viewer
I am using the BI Viewer to display bars for actual data and a line for the budget/target. My issue is when I split the values into two groups the items in my legend are doubling. So I see each one ...
Forum Discussion
Is the problem that when you split the values instead of it properly allocating it is still showing the total as if it rolled up to the parent but doubles it?
thanks,
nick hymes
archetype consulting
The data source is a Cube view with Time in Columns, a row for actuals by region (UD3), and a row for UD3 Top Budget.
I have two calculated fields in the BI Viewer:
Pulling Budget at top:
Iif([UD3]='Top',[Amount],0)
Pulling Actuals at UD3 Parents:
Iif([UD3]<>'Top',[Amount],0)But even though the regions only have a value for Actuals it is showing in the Legend for Actuals and Budget. As I mentioned the chart itself is accurate, but the Legend is very busy showing data intersections that I would think are filtered out by my calculated fields.
I also tried without the calculated fields and doing the filter on the Value in the Pane but that had the same result.
Essentially, I am trying to get the circled items below removed from the legend.
Calculated Fields are not filters. What you are doing there is just setting values to zero, but the data points (the records) are still there, hence they show up in legend.
What you want is to go in the Data tab on the ribbon, click "Edit filter", and set a filter to exclude the stuff you don't need. If that doesn't work, your filter is not set properly or you have records that match the filter and you don't realize it (or we have a bug, which is always possible, but the point is: what you want is filters, not calculated fields).
Can you try that and then post your filters if it doesn't work?
That was what I tried initially but that didn't work so tried doing as the calculated field. Here is with the filters on the values, you can see below the 'hoover' legend looks good but the legend at the top still is including two of each.
