Forum Discussion

Kashish2805's avatar
Kashish2805
New Member
1 year ago
Solved

Slicers Across Datasets

I have imported multiple tables (all Excel) into Power BI I have connected them through a text variable "Customer Name"   In one of the tables, I have 3 columns, "Customer Name, "Service", "Y or...
Need Help
  • danextian's avatar
    danextian
    1 year ago

    Hi Kashish2805 

    These four tables need to be connected via dimension tables to enable slicing and dicing. In the screenshot below, you'll notice that two fact tables are connected through dimension tables for the common dimensions between them. These dimensions must include the distinct values from all the two tables and are to be used in the visuals.  Please see the attached pbix.

     

     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi Kashish2805 ,

Did the above suggestions help with your scenario? if that is the case, you can consider Kudo or Accept the helpful suggestions to help others who faced similar requirements.

If these also don't help, please share more detailed information and description to help us clarify your scenario to test.

How to Get Your Question Answered Quickly 

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    HI Kashish2805 ,

    Any update on this? Did these suggestion helps?

    Regards,

    Xiaoxin Sheng