Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
Does anyone know if Tabular Editor is able to read parameter values from the model?
I am creating a Power BI model that is made up primarily of parameter values that interact with each other. There are no data tables in the model other than a list of years. I like to write DAX in Tabular Editor but it doesn't seem to read SELECTEDVALUE when I have a slider selection in the model. For example, I have a measures like this:
Solved! Go to Solution.
I don't think its possible for Tabular Editor to read the selections in slicers, but you can simulate it using TREATAS and variables. e.g. if you had a date slicer and a color slicer you could emulate the user selections with something like
DEFINE
VAR myFilter =
TREATAS (
{ ( 2022, 6, "Red" ) },
'Date'[Year],
'Date'[Month number],
'Product'[Colour]
)
EVALUATE
SUMMARIZECOLUMNS ( 'Product'[Brand], myFilter, "Sales Amount", [Sales Amount] )You can use multiple filters in SUMMARIZECOLUMNS, so you could potentially have one filter per slicer rather than combining them.
@johnt75 , Thanks, that's a great suggestion and will work for what I'm trying to do. I appreciate your input!
I don't think its possible for Tabular Editor to read the selections in slicers, but you can simulate it using TREATAS and variables. e.g. if you had a date slicer and a color slicer you could emulate the user selections with something like
DEFINE
VAR myFilter =
TREATAS (
{ ( 2022, 6, "Red" ) },
'Date'[Year],
'Date'[Month number],
'Product'[Colour]
)
EVALUATE
SUMMARIZECOLUMNS ( 'Product'[Brand], myFilter, "Sales Amount", [Sales Amount] )You can use multiple filters in SUMMARIZECOLUMNS, so you could potentially have one filter per slicer rather than combining them.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 8 | |
| 6 | |
| 5 | |
| 5 | |
| 4 |
| User | Count |
|---|---|
| 25 | |
| 16 | |
| 8 | |
| 7 | |
| 7 |