Forum Discussion

dkr's avatar
dkr
Frequent Visitor
8 years ago
Solved

Dynamic Table based on Slicers

Please excuse the newbie question...   I have created my first report, with a slicer which work as expected.  I am now trying to take it one step further by adding another slicer, but have hit a st...
  • anandav's avatar
    anandav
    8 years ago

    Hi dkr,

    As you have mentioned amy be you can create a new table with unique values of table B and use that to create relationship with tables C and D. You will then use the new table valuces in Slicer B.

     

     You can create a new table by selecting the New Table buttion in Modelling tab.

    Table = Values('TableB'[Column1])

     

    If you can upload a pbix  file with sample data to a cloud drive and share the link, we could try to help.

anandav's avatar
anandav
Skilled Sharer
8 years ago

Hi dkr,

As you have mentioned amy be you can create a new table with unique values of table B and use that to create relationship with tables C and D. You will then use the new table valuces in Slicer B.

 

 You can create a new table by selecting the New Table buttion in Modelling tab.

Table = Values('TableB'[Column1])

 

If you can upload a pbix  file with sample data to a cloud drive and share the link, we could try to help.

  • dkr's avatar
    dkr
    Frequent Visitor
    8 years ago

    Many thanks for your help.  It was the Bi-Directional setting on the relationship that I had overlooked.