How to show default data(columns) along with the selection slicer

[Ngauti]

Hi,

I have two column i.e. Category & Location, what i need here is in Power bi

1) i want to see the default selection of US.

2) if i select other location for example: if i select "India" then it should display US along with India.

[speedramps · Accepted solution]

Try this download this PBIX soliution from OneDrive

Click here 

Create a detached picklist table with a list of locations.

Do not relate the picklist table to your data.

Create a slicer with the picklist location  (not from your data)

Create a measure

IsValid = 

// create a temporary table of picked location and US
var pickedlocations = 
UNION(
    VALUES('Location picklist'[Picking Location]), 
    {"US"}
)

// get the location for the current row/column cell in the visual 
var yourlocation = SELECTEDVALUE(Yourdata[Location])
RETURN
// if your location is in the list then it is valid

IF(yourlocation in pickedlocations, 1)

Display the measure with your data to check it works 

Then use the measure to filter your data

We are unpaid volunteers and you have got free expert help which took a lot of effort to write this detailed answer.
This solution works and does exactly what you asked.
So please quickly click the [accept as solution] and the thumbs up button to leave kudos.
If you need to change or extend your request then please raise a new ticket.
One question per ticket please !
You will get a quicker response and each volunteer solver will get the kudos they deserve.

If you quote @speedramps in your next tickets then I will then receive an automatic notification, and will be delighted to help you again.

However I decline to help impolite lazy members twice who ask misleading or incomplete questions and then dont accept the correct soltion.

Please now click the [accept as solution] and the thumbs up button. Thank you

[Ngauti]

Wonderfull, Thank you.

its working fine

[speedramps]

Thank you @Ngauti for the kudos.
If you need more help then raise a new ticket and quote @speedramps anywhere in the text, I will then receive an automatic notification and will be delighted to help you again.
Please always try provide example input data as table text (not a screen print) so we can import the data to build a solution for you. You will gain respect and much quicker and better responses with the more effort you put in to describing problems

[Ngauti]

in this case i don't want to hold the shift or ctrl key, 

just i will click one single selection as "india" then it should display US & India together

basically US's Value should be displayed default irrespective of selections 

[speedramps]

In Power BI just hold the shift or ctrtl key and  then click US and India, and both will be selected.

Learn more about keyboard shortcuts here

https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-accessibility-keyboard-shortcuts

We are unpaid volunteers and you have got free expert help which took a lot of effort.
This solution works and does exactly what you asked.
So please quickly click the [accept as solution] and the thumbs up button to leave kudos.
If you need to change or extend your request then please raise a new ticket.
One question per ticket please !
You will get a quicker response and each volunteer solver will get the kudos they deserve.

If you quote @speedramps in your next tickets then I will then receive an automatic notification, and will be delighted to help you again.

However I decline to help impolite lazy members twice who ask misleading or incomplete questions and then dont accept the correct soltion.

Please now click the [accept as solution] and the thumbs up button. Thank you