Forum Discussion

mpeters1988's avatar
mpeters1988
Frequent Visitor
8 years ago
Solved

Calculated Field for Slicer

Hi everybody,   I'm trying to find out whether or not Power BI allows you to create a column name and use that as the actual Field in a Slicer. As a test I created the following tables/datamodel: ...
Need Help
Tips and Tricks
  • v-ljerr-msft's avatar
    v-ljerr-msft
    8 years ago

    Hi mpeters1988,

    The reason I'm trying to do this is to dynamically fill a single slicer so a user doesn't need dozens of slicers on one page, but only two: one to select the field to filter, one to do the actual filtering/slicing.

    In your scenario, you should be able to use the Unpivot option in Query Editor to unpivot those columns(the value type has tp be the same) that you want to use as Slicers.

     

    After unpivoting, you'll get a Attribute column(Field names), Value column(Values). Then you can use only these two columns as Slicers on the report. For more details about how to use the Unpivot option in Power BI, you can refer to this article. :smileyhappy:

     

     

    Regards

v-ljerr-msft's avatar
v-ljerr-msft
Microsoft Employee
8 years ago

Hi mpeters1988,

 

What's this calculate field used for? Could you be more precisely with your expected result? :smileyhappy:

 

In addition, not like measures, calculate columns/tables are computed during database processing(e.g. data refresh) and then stored in the model, they do not response to user selections on the report.

 

So it is not possible to create a calculate column/table can change dynamically with user selections on the report.

 

Regards