Forum Discussion

rumittal's avatar
rumittal
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago
Solved

How to slice data in different charts from different tables based on same slicer ?

Hi,   I have two tables each of which have three identical columns - Team, TestSelectionBucket, ScenarioOwnerTeam. I am creating two charts based on each of them, and want to add three slicers at ...
Need Help
  • richbenmintz's avatar
    richbenmintz
    7 years ago

    Hi rumittal,

     

    you require a set of dimensions and a star schema. as an example you can create a 'scenario owner' dimension either at the data source with a view that gets the distinct values from both of your fact tables, with a dax calculated table

    Scenario Owner = DISTINCT(UNION(VALUES(consistency_across[scenarioowner]), VALUES('query1'[scenarioowner])))

    or within power query. Once you have the dimension create a 1->* relationship from the dimension to both fact tables, then add the dimension attribute as your slicer or filter element. 

    Voila a single filter to control them all!

TCarrasquillo's avatar
TCarrasquillo
Icon for Helper II rankHelper II
7 years ago

 

Hi,

 

I  think all you need to do is edit the interactions for your two charts. Select a slicer, go to format and click edit interactions. When you hover over your charts you should see a few icons on the top left corner. Click on the funnel/filter icon for both charts.

  • rumittal's avatar
    rumittal
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi,

     

    I guess below solution works only when both charts that you are trying to slice with the help of slicer have some relationship defined to it in the data model. Else just two individual charts with individual table sharing a common column , is not being able to sliced by the slicer created on values of the common  column.