Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
@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...
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...
Hope they can help you find the solution that best fits your needs.
Best Regards
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...
Hope they can help you find the solution that best fits your needs.
Best Regards
@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...
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
104 | |
99 | |
98 | |
38 | |
37 |
User | Count |
---|---|
158 | |
120 | |
74 | |
72 | |
63 |