Slicer selection has no values but visuals default to one of the other selection

[Ggeorge85]

Hi!

I am having an issue with my power Bi report. I am visualising spending in the report for a few cost centres. I have a slicer for region of spend. There are 3 regions are 'GBL, USA, Blank'. Blank is when the information was no provided in the ERP system. I then have a budget table to compare the spending to. The budget table does not have 'Blank' region. When i create a guage and bar chart visual, when blank is selected in the slicer, they show the actual spend correctly, however for the budget component, they default to the 'GBL' budget values. I will need the 'Blank' option in there as it is part of our actual costs, however they should be comapared to a 0 value budget i.e overspend, as we have no budget for 'Blank' region'. 

Things to note:

1) I have filter on the page to filter to filter for transactions for a few cost centers only

2) Filter on slicer visual (budget true?, Spend true?) is to return regions that are not empty value

3) Budget value is based on a measure to sum amount in budget table if it meets the cost centre criteria.

4) When selecting 'GBL' or 'USA' the visuals work perfectly, but when 'Blank' is selected, they budget components defaults to 'GBL' values

5) Budget table does not have anything that references 'Blank'.

6) Region slicer values come from the 'Region' table

[lbendlin]

You can exclude (Blank)  in the filter pane if that is what you want to do.  

Power BI adds these to alert you that your data model is not covering.

[Ggeorge85]

Unfortunately I need blank as my actual spend has blank region, but my budget doesn't.