Forum Discussion
Slicing Common data-set using multiple slicers
Hi ack2mani,
I have 3 slicers in my page and One common dataset. Is there any way to filter same dataset with 3 slicers, provided all 3 slicers are in Parent-Child relationship and are 3 diff datasets, and main dataset containts common data which should be filetred based on the selection in any of the slicer. I am unable to acheive this since more than one active relationship on my Common dataset is not alllowed in Power BI. Please let me know If more clarity is required.
Based on your description, if I understand your scenario correctly that you have a dataset with three data source?
If it is convenient, could you share a screenshot of the relationships for your tables and what you want to achieve in Power BI Desktop?
Best Regards,
Cherry
Hi v-piga-msft
Thanks for quick reply. I cant's share the screenshot but I can explain in detail
I have Hierarchy like IDN-HealthSystem-Hospitals being IDN as Parent of Healthsytem and Healthsystem is parent of Hospital. So I have 3 Slicers in report i.e IDN, HealthSytem and Hospital and 3 slicers have 3 diff dim tables. I have one Fact table which is having common data for IDN ,HealthSystem and Hosp. My requirement is any selection in filters should reflect corresponding data from fact table.
Common Fields
Dim_IDN (idn_id)
Dim_HealthSystem(hs_id,idn_id)
Dim_Hos(hsp_id,hs_id)
Fct_Financial(ID)
Id column in fct_Financial is same as idn_id,hs_id and hsp_id one recors per id .
So can we acheive this?