Forum Discussion

yakovlol's avatar
yakovlol
Icon for Resolver I rankResolver I
2 years ago
Solved

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

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 

  • 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

4 Replies

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

    • yakovlol's avatar
      yakovlol
      Icon for Resolver I rankResolver I

      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's avatar
        lbendlin
        Icon for Super User rankSuper User

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

  • 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