Forum Discussion

H3nning's avatar
H3nning
Helper V
1 year ago
Solved

One Slicer, multiple Parameters

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 se...
Need Help
  • PBIViz_2024's avatar
    PBIViz_2024
    1 year ago

    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's avatar
H3nning
Helper V
1 year ago

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's avatar
PBIViz_2024
Advocate I
1 year ago

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's avatar
    H3nning
    Helper V
    1 year ago

    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's avatar
      PBIViz_2024
      Advocate I
      1 year ago

      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's avatar
        H3nning
        Helper V
        1 year ago

        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???