One Slicer, multiple Parameters

[H3nning]

Hi,

I already found a few topics about this and they have accepted solutions, but I just dont get it yet. Maybe its because Im not really sure how the field parameter syntax works.

I have two sets of measures im my model. To keep it simple its 4 in total.

Sales measure 1

Sales measure 2

Revenue measure 1

Revenue measure 2

What i want to do is, I want to show the two sales measures or the two revenue measures in a stacked bar chart, but one at a time depending on one slicer. So only the sales measures OR the revenue measures.

In my understanding this can be done by expanding field parameters somehow, but it did not work.

Parameter = {

    ("Sales", NAMEOF([Sales measure 1]), 0,"Sales"),

    ("Revenue", NAMEOF([Revenue measure 1]), 1,"Revenue"),

    ("Sales", NAMEOF([Sales measure 2]), 3,"Sales"),

    ("Revenue", NAMEOF([Revenue measure 2]), 4,"Revenue")

This resultet in a new colum value 4 and i dont know why. Can anyone explain how this works?

Thank you so much!

[PBIViz_2024]

Hi,

I believe you have manually written this to generate a field parameter.Here is how you should do it.

Go to Modeling Tab->New Parameter->Field

Then do as below screenshot,

Then Click on "Create" Button.Your field parameter will be available to use and it will automatically generate the slicer also.

correct syntax for the field parameter is shown below.But do not write it manually instead follow the above steps.

[H3nning]

But this will only make it possible to switch between the 2 sales measures. I want to display BOTH sales measures or BOTH revenue measures in a stacked bar chart for example.

[PBIViz_2024]

Hi,

For that first create the Field parameter with all 4 measures as explained before.

That will result a slicer looks like below,

and then in slicer settings disable mutli selction with Ctrl

you will be able to easily select whatever the measure/measures you want.

[H3nning]

No that wont do it either Im afraid. But thank you so far anyway. In the end it want a slice with 2 options "Revenue" and "Sales". When I select Sale my barchart shows the two sales measures and when I select Revenue its the 2 revenue measures. 

My example with 4 measures is just to simplify. In reality I have 6 or 8 measures per option and I dont want the user to be able to mix them or to be obliged to select each one, one by one...

[PBIViz_2024 · Accepted solution]

I think I got your issue now.my last try.check this

You have to bring value4 to fields for the slicer and for the y axis of the graph do below,

I hope this works

regards,

[H3nning]

All visuals are empty... This is my code with real fields:

TestOneSlicer = {

    ("GewichteterRestBetrag0-30", NAMEOF('Measures (2)'[__GewichteterRestBetrag0-30]), 0,"Revenue"),

    ("GewichteterRestBetrag31-60", NAMEOF([__GewichteterRestBetrag31-60]), 1, "Revenue"),

    ("GewichteterRestBetrag61-90", NAMEOF([__GewichteterRestBetrag61-90]), 2, "Sales"),

    ("GewichteterRestBetragGr90", NAMEOF([__GewichteterRestBetragGr90]), 3, "Sales")

    }

But value 4 in slicer results in an empty slicer:

Why???

[PBIViz_2024]

Hi,

It is hard to tell without looking at it.please check my test pbix.test .this is how it should come,

regards,

[H3nning]

Thank you, but maybe stupid question: How am I supposed to open that? When I click it I get to a folder somewhere, but there is no pbix...

There are no direct syntax errors in my code though, rigth?

[H3nning]

Ok, I found my mistake. Works now. Thanks a lot!