Automtic filter selection on the second dataset of page

[anshenterprice]

Hi Team,

I have two datasets

Data set 1			Data set 2
Category	Stockname	Value			Category	Stockname	Value
Equity	Reliance	3			Equity	Reliance	3
Equity	Olectra	4			Equity	Olectra	4
Equity	JBMA	1			Equity	JBMA	1
Commodity	PFC	3			Commodity	PFC	3
Commodity	Crud	5			Commodity	Crud	5
Commodity	ONGC	1			Commodity	ONGC	1

I have two datasets the above its just sample data but we have more columns but simmiler column just i added in the above dataset and two powerbi pages

in the first power page(dataset1)- date and Stockname are slicer , once we select any stockname from the filter its diplaying data on the page and the second page(dataset2)- date and Category are slicers once we select any catergory then its displaying all stocks related informatin in the page

requirement- when user select any stock name from the firstpage and once he goes to second page then it should select under the same catergory related information with the date also.

Thanks

[amitchandak · Accepted solution]

@anshenterprice , Create common dimension tables category and stock name and then join them back with , Your tables and use dimensions in visual

Stockname= distinct(UNION(distinct(Dataset1[Stockname]), distinct(Dataset2[Stockname])))

Category = DISTINCT(UNION(DISTINCT(Dataset1[Category]),DISTINCT(Dataset2[Category])))

Then use drill through

Power BI Drill Through - More than one level: https://www.youtube.com/watch?v=hCAAvpppQmk

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...

[v-yiruan-msft · Accepted solution]

Hi @anshenterprice ,

@amitchandak has already provided a viable solution, you can check if it is suitable for your scenario. Here there is another method to achieve your requirement, you can find the details in the attachment...

1. Create a relationship between the table 'Data set 1' and 'Data set 2' base on the field [Stockname]

2. Create a slicer which applied on the field 'Data set 1'[Stockname]in page 1 and page 2 separately, and they are sync slicers. Then when you select any option in page 1, it will sync in page 2...

Page 1

Page 2

Hope they can help you find the solution that best fits your needs.

Best Regards

[amitchandak · Accepted solution]

@anshenterprice , Create common dimension tables category and stock name and then join them back with , Your tables and use dimensions in visual

Stockname= distinct(UNION(distinct(Dataset1[Stockname]), distinct(Dataset2[Stockname])))

Category = DISTINCT(UNION(DISTINCT(Dataset1[Category]),DISTINCT(Dataset2[Category])))

Then use drill through

Power BI Drill Through - More than one level: https://www.youtube.com/watch?v=hCAAvpppQmk

Power BI- DAX: When I asked you to create common tables: https://youtu.be/a2CrqCA9geM
https://medium.com/@amitchandak/power-bi-when-i-asked-you-to-create-common-tables-a-quick-dax-soluti...