Field Parameters - is it possible to replace by calculation group?

[yakovlol]

Hello! 

I'm using the Power BI Report Server, and unfortunately - in the report server server there are still no available Field parameters. 

I've already tried to create it on PBI Dekstop - but when I switch to the report server version - field parameters don't work, unfortunately. And I am looking for some work around how can i do it by Calculation group for example.

The problem is:

 I have one table and two columns Product and Subproduct, values of sales

And in visualization I have a bar chart distributed by year-month and sales, and the request is to do dynamic legend - so to check total sales by product (if select product) or by Subproducts (selected by Subprodcuts)

In Field Parameters it is very simple to do - so just select two columns and then this created parameter drag and drop to Legend.

Maybe there is a chane do something like this via Calculation groups? or any other suggestions, will be much appricieted 

[yakovlol · Accepted solution]

I didn't find a way how to work around field parameters and tried to make changes on my model, but nothing that could help to do the same as field parameters does

[lbendlin]

As I understand it Calculation Groups are only for measures, whereas Field Parameters can be used for either columns or measures.

[yakovlol]

Hello, @lbendlin tthanks for your reply and Is there any way how we can handle it differently for columns not using Field parameters? Something we can do instead of this feature?

[lbendlin]

Enable "Personalize Visuals" and teach your report users how to use it