- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

Automtic filter selection on the second dataset of page
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

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
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content

@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...

Helpful resources
Subject | Author | Posted | |
---|---|---|---|
07-24-2024 07:51 AM | |||
09-20-2024 05:38 AM | |||
07-05-2024 04:25 PM | |||
09-03-2024 03:39 PM | |||
08-26-2024 05:50 AM |
User | Count |
---|---|
141 | |
111 | |
81 | |
61 | |
46 |