Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

How to create dynamic calculated column in PowerBI

Hi community, I need to show KPI of one single company compare with rest of the market in the dashboard, so want to add a dynamic calculated column( value be like "focus company" & "rest of market") into the raw table, and I need this column's value automatically changed based on user's choice of that single company. The user can choose the focus company they are interested in a slicer.  In tableau, it's easy to achieve this by using parameter. but I haven't found a solution in PowerBI yet. Does anyone did similar thing in powerBI before? Thank you!

2 Replies

  • AntrikshSharma's avatar
    AntrikshSharma
    Icon for Community Champion rankCommunity Champion

    Anonymous Calculated columns can't be dynamic, as no Filter Flows from Report View to the Data View.

    • Anonymous's avatar
      Anonymous
      Not applicable

      I see, thank you!