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 get the fields from Table : Profit

If Loss is selected in the slicer.
All my visuals should get the fields from Table : Loss.

Any idea or any link how can i go.
Thanks in advance !

 

Need Help

4 Replies

  • AbbasG's avatar
    AbbasG
    Memorable Member
    3 years ago

    Anonymous Hi, one way of achieving this is through bookmarks. Please refer to the below pbix file.
    Hope it helps.
    PBIX 

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Thanks for the reply.

      Yes bookmark will work.

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

      So book mark will be tough to handle.

  • 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.