Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Add manual comment in table after filtering data

Dear Community,

 

Need your help, Iam facing issue adding "comment" after filtering columns "FDD Support, Device Type and 4G capability".

 

After applying filter => Add column => Column ="3G capable". then 3G capable text is applied on complete "comment" column rather than only filtered rows. How can I type seperate text after filtering data? 

 

P.S. "FDD Support, Device Type and 4G capability" columns are taken from other sheets using LOOKUP function.

 

 

 

 

Br,

Amir Ansari

 

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi Anonymous,

    In fact, power bi does not support create a dynamic calculate column/table that responds with filter/slicers that host on the visual data levels. You need to use measure expression instead.

    Notice: the data level of power bi.

    Database(external) -> query table(query, custom function, query parameters) -> data model table(table, calculate column/table) -> data view with virtual tables(measure, visual, filter, slicer)

    Regards,

    Xiaoxin Sheng