Need help on PowerBI Functionality

[arun2001mjl]

Hello All,

I need your help on PowerBI. Attached excel file is uploaded to PowerBI.

I have Package and Accounts as a Column in Excel (Sample Data). I have created a Stacked Bar Chart based on Packages and Accounts as in attached excel.

For Example.. In below visual, i have unselected "5-Unknown" from Sliver, Bar chart should remove all accounts(BBB,CCC,EEE) which was "5-Unknown", but as per Functionality it is showing all accounts and Packages except "5-Unknown".

Do we have any solution to disable the Unknown accounts from Bar Chart which has "5-Unknown" as Package when we uncheck "5-Unknown" from Slicer?

Please help me.

Regards

Arun

[arun2001mjl]

We tried that as well but it was still showing the Account which has "5-Unknown".. If i unselect "5-Unknown" from slicer, i dont want to see the accounts in visual which has this "5-Unknown".

[amitchandak · Accepted solution]

@arun2001mjl , Use visual or page level filter and remove that value

[arun2001mjl]

Hi Amit,

When i unselect a Package from Slicer, we do not want to show companies that are related to particular selction.

For Example.. I have unselected "5-Unknown" from Slicer. In that case, Bar chart should not show the accounts(BBB,CCC,EEE) which was "5-Unknown", but as per the Functionality it is showing all accounts which has other Packages except "5-Unknown".