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
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.
Can you show us the actual filter?
If we can't see any problem there, then it becomes something you should file with Support.
I would try to use
Not Contains([UD3], 'Top')Just to check that it isn't an issue with hidden spaces or bugged equality.
Also, right-click on the chart and select Inspect Data, making sure that there is no line for Top.
If you do all of that and it still shows up, it could well be a defect you have to speak about with Support. I'm testing on v.7.4.1 and don't see that behavior.