Forum Discussion

ack2mani's avatar
ack2mani
Frequent Visitor
8 years ago

Slicing Common data-set using multiple slicers

Hi Frinds,

I need your urgent help in one of the requirement where I have stucked.

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.

 

Many Thanks in Advance

Need Help

2 Replies

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    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

    • ack2mani's avatar
      ack2mani
      Frequent Visitor
      8 years ago

      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?