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.

     

     

danextian's avatar
danextian
Super User
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.