Parameter Table for Slicer

Power BI
1

Hi

image
image.png1089×117 15.6 KB

I don’t have access to create a new table. Is there any other way to create a parameter list of values for Slicer without creating a table in data model.( through DAX formulas). I need a static list of values for example

Prev Year
Current Year
Next Year
Forecast
.
.
.
Is it possible to create a New measure with the static list.

Thanks

2

@Namjan,
Measures cannot be used as filters ( slicers, rows, columns, etc). Do you have access to create a new table under the Modeling tab? If so, you can use the following to create table:
Data%20Table

Table = 
DATATABLE(
    "Static List", STRING, 
    { 
        {"Prev Year"},
        {"Current Year"}
    }
)
3

No I don’t have access to create a new table or access to data model as it is a shared one.
Is there any dax function that can work
image
Thanks

4

Hi,

Is it possible to create a parameter table for slicer using DAX

Thanks

5

Are you using Direct Query mode? This seems the most likely based on what you can’t do.

You are really limited in what you can do with this mode, as you can’t make any changes to the model inside of Power BI.

Therefore you can create a parameter table.

This can’t also be done just with DAX measures also.