powerbidax

Power BI: add slicer value into table


My data model has one table, Tbl. It has a few fields including F1.

On my page, there is a slicer (filter) on F1. I want to build a measure that returns the filtered value for F1 and add it to a table visual.

The visual would look as such:

F1 (all values) | F1 (filtered value)

How can I do this?


Solution

  • This is a bit tricky since you want the slicer to affect one column but not the other.

    What I would do is create a new table to use in a slicer.

    Modeling > New Table: Slicer = VALUES(Table1[F1])

    Then use Slicer[F1] for you slicer instead of Table1[Slicer] and define a measure

    Selected F1 = MAX(Slicer[F1])
    

    (You can use a different function like LASTNONBLANKor SELECTEDVALUE instead of MAX if you prefer.)

    Then if you set up your table with Table1[F1] and [Selected F1], it should look like this:

    Slicer Selection