Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Dynamically change the table based on slicer selection.

Hi Team,   I have 2 Tables(Profit and Loss)which has same set of columns. I have a slicer which has option to select : 1)Profit 2)Loss If profit is selected in the slicer. All my visuals should...
Need Help
PaulDBrown's avatar
PaulDBrown
Community Champion
3 years ago

You can create a separate table for the slicer using:

Metric = {"Profit", "Loss"}

Then create a measure along the lines of:

metric measure = IF(SELECTEDVALUE(Metric[Value]) = "Profit", [Sum Profit], [Sum loss])

 

where the sums follow this pattern:

Sum Profit = CALCULATE (SUM(Table[Value]), FILTER(Table, Table[Type] = "Profit"))

where 'Table' is the fact table and 'Table'[Type] is the field which establishes the type for the values.

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks for the reply.

    Here i am not looking for sum and filter the column.

    I am trying to select the Table based on the value selected in slicer.

    i have more number of pages and many visuals across all pages.

    All visuals and pages should point to the table based on slicer selection.