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.

v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi dkr,

>> I think I need to create an intermediary dynamic table which just holds the unique values from Table B after a selection has been made on Table A and use these results in my 2nd slicer instead of Table B. 

 

 It's possible to create a dynamical calculated column/table based on slicer, please review this knowledage base: Calculated Column/Table Change Dynamically According to Slicer Selection in the Report.

You can create a measure to get the selected value of a slicer by using SELECTEDVALUE.

Best Regards,
Angelia