Forum Discussion
Anonymous
5 years agoNot applicable
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
Community Champion
Anonymous Calculated columns can't be dynamic, as no Filter Flows from Report View to the Data View.
- AnonymousNot applicable
I see, thank you!