Forum Discussion

FOXYBARK's avatar
FOXYBARK
Icon for Helper III rankHelper III
11 months ago
Solved

Separate hierarchcal slicers

HI there.  I'm on PBI v 2.141   I have 2 slicers that I need to keep separate. Slicer 1 should automaticaly filter Slicer 2 so that only that applicable values are shown in S2 based on what is sel...
Need Help
  • v-pnaroju-msft's avatar
    v-pnaroju-msft
    11 months ago

    Hi FOXYBARK,

    Kindly share sample data in a structured format (not as an image) to help us better understand your query. Please also include a screenshot of your Model view showing all related tables and relationships, along with the table names and columns used in each slicer. Additionally, provide 2 to 3 sample rows from each relevant table (excluding any sensitive information) and specify the expected outcome based on your example.

    Thank you.

parry2k's avatar
parry2k
Icon for Super User rankSuper User
11 months ago

FOXYBARK I believe they both are from different tables. Is there a fact table or other table in between that has a relationship with these two tables?

FOXYBARK's avatar
FOXYBARK
Icon for Helper III rankHelper III
11 months ago

Hi there. 
I read the post you provided. I can confirm there is a table that is in the middle of both my property and my business grouping table. My [Dollars] table is at the center of both. 

My property table is joined to dollars using the [property] field and the business expense table is joined using the [expense] field.